How to MTD high value as Green and low value as Red expression in Pivot Chart?

[ishansjain2095]

Hi,

Is there any way to to show high value as in green color and low value as red color in sum of sales value where comparing Date as 'dimension' and sum(sales) as 'measure'. Check date wise in decreasing order in qlik sense Pivot Chart....

[Usama]

Hi,
You can use below text color expression for any column to show high values in green and low values in red 

If(Column(3)>0,Green(),Red())

the output will be like this as:

Thanks

[ishansjain2095]

Hi Usama,

I actually have sale details as +ve values like 100,1000,1001,101. Compare as 101 is less value than 1001 so 101 should be in red color and 1001 should be in green as vice versa for all other values using high and low expression....

Can you make the expression like above ?