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
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
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
Specialist III
Specialist III

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
Specialist III
Specialist III

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)