Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

HELP WITH COLORMIX IN A COLUMN

Hey guys How Can I create a COLORMIX function to work on my following table:

 

Imagem2.png

 

I'm trying to make a gradient over the third column, colloring row by row.

My expression is

Num((SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL)
-
SUM({<DATA={'$(=AddMonths(Max(DATA),-12))'}>}RISCO_TOTAL))
/
SUM({<DATA={'$(=AddMonths(Max(DATA),-12))'}>}RISCO_TOTAL),'#.##0,00%')

4 Replies
Highlighted
Valued Contributor III

Re: HELP WITH COLORMIX IN A COLUMN

try ColorMix function it will allow gradient

Channa
Highlighted
Contributor

Re: HELP WITH COLORMIX IN A COLUMN

Hy Channa, that's what I'm trying to do. I don't know how to use ColorMix on my expression.

Tks!

Highlighted
Valued Contributor III

Re: HELP WITH COLORMIX IN A COLUMN

colormix(IF(Sales)<100,Red(),White())

Channa
Highlighted
Contributor

Re: HELP WITH COLORMIX IN A COLUMN

Hi Channa,

Actually I can't set 100% as my indicator because the percetuals can be change.

It should colour auto from the colors.