topic ColorMix in PivotTable in App Development

ColorMix in PivotTable

Albert2 — Fri, 13 Aug 2021 09:27:16 GMT

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')

Re: ColorMix in PivotTable

Emile_Koslowski — Tue, 17 Aug 2021 09:44:43 GMT

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

Re: ColorMix in PivotTable

Albert2 — Tue, 17 Aug 2021 12:36:32 GMT

Thx Emil!

Re: ColorMix in PivotTable

cotiso_hanganu — Wed, 18 Aug 2021 15:12:05 GMT

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 !