ColorMix in PivotTable

[Albert2]

Hi,

I want to highlight values in a pivot tabl.

Now i have function colormix1 but they is only referencing on each single row:(

This is my secend  function, but dosn't work 

colormix1(count(e_sale_amount)/max(total aggr(count(e_sale_amount),[calendar.month],[item.plan_category_name])),LightRed(),yellow())

dimesions row =[item.plan_category_name]

dimension columns =[calendar.month]

measures =NUM($(e_sale_amount), '#.##0')

[Emile_Koslowski]

Hi,

Is this a question about Qlik Application Automation or Blendr.io?
If not, I think you're asking this on the wrong part of the forum, maybe try it on the Qlik Sense part: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Emile

[Albert2]

Thx Emil!

[cotiso_hanganu]

I believe it's about using a colormix function in interface of Qlik Sense => it's kind of off-topic....

But best place to create coolest colormix calls, is using the colormix wizard in Qlikview Expression Editor Menu !