Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can I make a table who change color in a dynamically cell.

for example ,I have an expression in descending  order and need a gradual change  color depending by the position.

can anybody help me?

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

You can change color depending by the value so for example if your values are between 0 and 100 you can set an expression for color like this:

if(value>0 and value <20, rgb(x,y,z),

if(value>20 and value <40, rgb(x1,y2,z2),

rgn(x3,y3,z3

)

)

It's an idea ... hope it helps

Gysbert_Wassenaar

You're probably looking for the colormix function. You can find an example here: Re: Qlikview Heatmaps


talk is cheap, supply exceeds demand
Not applicable
Author

thanks a lot Alessandro,you help me  too much

Not applicable
Author


Gysbert thank you so much.