Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

2 color gradients in pivot chart

Hi Community,

I am having trouble with formatting the background of cells for a pivot chart. I would like to utilize the two color gradient coloring and set a condition so that based on the item, the cell background changes accordingly.

Please view the attached dashboard. 

I have three different color scales I would like to institute and I do not know how to do the gradient version. 

Any help rendered will be truly appreciated. 

Labels (1)
2 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi. Try this expression color:

 

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(0,0,205), rgb(250,128,114))

ZoeM
Specialist
Specialist
Author

Sorry for the late response Pablo.

I tried using your expression and I could not get it to work in the sample