Can anyone help me with qlik sense expression i.e. comparing Col C4 with C7 and range the values in color form as shown in the attachment shared below?
Well rule for colors are:
|Yellow||T4 +>1% to 20%|
|Green||T4 + = 0 to 1%|
These ranges should be compared with col T7 as shown in attachment.
Well T1 is date of purchased items and T2 is based on ratio of each products. Can you just help me with the T7 column that how to get background colour in qlik sense colour expression.
Yes. But I want to know which are the actual data columns? from T3 onwards all are calculated. So I need to build the logic on actual data columns and then calculate others. Are T1 & T2 columns actually available in data or they are also calculated
as per the data. Create a Table chart. Add below Measure
Now in Measure properties->background colour expression, put below expression
=if(column(1)>0.01 and column(1)<=0.2, Yellow,
if(column(1)>0.2 and column(1)<=0.5, Orange,
if(column(1)>0.5 , Red, Green)))
Note: Define colors with RGB function or you can use Html color codes eg. ('FF5733')