Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Bar chart color help

Hi Experts,

Can any one please help me on below requirement.

I have a bar chart with

1Dimension : Category

2Measures :  =Sum({<Year={$(=Max(Year))}>}sales)

                    =Sum({<Year={$(=Max(Year)-1)}>}sales)

I have to apply below specified colors for each bar.

I have tried color by expression based on dimension like below.

=if(Category='Low',RGB(0,0,0),

if(Category='High',RGB(255,0,0),

if(Category='Medium',RGB(128,128,128)

)))

By the above expression 2017 and 2018 High bars getting red color but need to show 2018 High  bar as red and 2017 High bar as orange.

Please help me on this. Please find the attached app.

RGB BAR CHART.png

Thanks in advance.

1 Solution

Accepted Solutions
silambarasan130
Contributor II

Re: Bar chart color help

Given the solution in the attached application,

this may be help you. ! !

1 Reply
silambarasan130
Contributor II

Re: Bar chart color help

Given the solution in the attached application,

this may be help you. ! !