Discussion board where members can get started with Qlik Sense.
I have added custom colors by expression to my bar chart. If my measure is 1 the customized colors effect the line chart, but if I have a staple, if my measure is > 2, the bars have only one color.
At the bars with the number 3, the first bar should be yellow and the upper one gray.
My expressions by color are:
IF(Status = 'finish', color1,
IF(Status = 'open', color2,
IF(Status = 'wait', color3))
Thank you for your help!
Go to Solution.
I would remove the 3 expressions and replace with count(Status).
Then add Status as a dimension
This will give a stacked bar chart.
You can colour by dimension or use your if formula that should work now
Can you attach the qvw
if possible can you share qvf file?
IF(sum(mesure) = '1', color1,
IF(sum(mesure) = '2', color2,
IF(sum(mesure) = '3', color3))
hi, i have attached it.
i have now
This works. Thank you very much!