Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ishansjain2095
Creator
Creator

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

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....

Labels (2)
2 Replies
Usama
Creator
Creator

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

Usama_0-1597927448637.png


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

the output will be like this as:

Usama_1-1597927547116.png

 


Thanks

From Nothing - To Something - To Everything
ishansjain2095
Creator
Creator
Author

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 ?