Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ascioneanna
Contributor III
Contributor III

Colormix1 gradient pivot:

Hi,

I'm working on a qliksense document. I need to color the pivot table according to the measurament: Incidenza Ordini su Totale

Logics to color: the major in green and the worst in red (with the shades of colour in the centre).

Now i used :ColorMix1( rank(total column(1))/noofrows(TOTAL) , lightred(),LightGreen())

But is not correct to my Logics to color: the major in green and the worst in red (with the shades of colour in the centre).

I attach the qliksense app and the picture of what I want to replicate with qliksense.

1 Solution

Accepted Solutions
brunobertels
Master
Master

Hello Anna Maria

May be this way :

ColorMix1( hrank(total column(1))/NoOfColumns(TOTAL) , lightgreen(),lightred())

replace renk by hrank and NoofRows by NoOfColumns

See below and chek if it's OK with desired outpout :

regards

View solution in original post

2 Replies
brunobertels
Master
Master

Hello Anna Maria

May be this way :

ColorMix1( hrank(total column(1))/NoOfColumns(TOTAL) , lightgreen(),lightred())

replace renk by hrank and NoofRows by NoOfColumns

See below and chek if it's OK with desired outpout :

regards

ascioneanna
Contributor III
Contributor III
Author

Yes, Now it works. Thank you Bruno

Can You Help me about this post too?

FieldValue('NumAcquisto',FieldIndex('Label',Label)