Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

table background coloring based on the value

Hello,

I have again a question or problem and hope somebody can help.

I have created a straight table which is somehow dynamically, this means the user can choose dimensions and expressions by himself and the straight table will be updated. i want now to color the background according the value of the table, but i dont want to use the formula behind, because this formula is somehow complicate because of the dynamic calculation. Is there a possibility to color it automatically based on the calue of each cell?

i would like to define ranges like

If(cellvalue<0.7,RGB(165,0,38),If(cellvalue<0.9,RGB(217,239,139),If(cellvalue<1.0,RGB(102,189,99),If(cellvalue<1.1,RGB(244,109,67),If(cellvalue<1.5,RGB(253,174,97),If(cellvalue>=1.5,RGB(0,104,55)))))))

thanks, armin

0 Replies