Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

How to create hexcolors with expression in pie chart (dynamic number of values)

Hi Community,

I would like to create a pie chart, filled with my own colors (for example: #AAAAAA,#BBBBBB,#CCCCCC).

My dimension can have 1 to 10 possible values, in my example: 3:


Most common value must have  #AAAAAA, 2nd: #BBBBBB, 3rd: #CCCCCC

How to realise this? I tried options like firstsortedvalue in combination with a if condition and with use of a variable, but I hope anybody can help me.

Thanks in advance!!

Grtz. Pascal

Community Browser