Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Grid Percent Graph conditional Foreground Color

user12137969May 15 2025 — edited May 15 2025

Hi community,

is it possible to set the foreground color for a percent graph in an IG conditional with passing variables to the settings ?

In the IG -SQL i have some

,case
when nvl(tvalue,0) = 0 then NULL
when(tvalue >= 90) then '#ff3b30'
when(tvalue >= 75) then '#ffcc00'
else
'#4cd964'
end as graphcolor

but i have no luck to pass the value in the foreground color settings…

I tried different expressions and values, nothing is working, only the options from the field.…any ideas?

i found no samples in the IG sample app or the ig cookbooks…

i am on apex 24.2.5

thanks in advance

dirk

This post has been answered by Karel Ekema on May 16 2025
Jump to Answer
Comments
Post Details
Added on May 15 2025
3 comments
220 views