Color bar chart by expression

Wed, 01 Jun 2016 09:40:19 GMT

I'm trying to replicate a bar chart in Qlik Sense that we previously made in Qlikview. The thing is that many of the options available in Qlikview do not exist in Sense.

So, this is the original chart:

And this is what I'm getting in Sense:

(I know the numbers aren't quite the same, this is because of new data that has been loaded in Sense but not in Qlikview).

What I'd like to know is a way to make the inferior bars in each case gray, like we did in qlikview.

In qlikview we used one dimension (X), and two expressions: (Y, with colors) and (Z, without colors). To obtain thiswe added an IF statement in the background color of that expression.

If anyone knows some way to accomplish this we'd be very grateful.

Many thanks,

Joan

Re: Color bar chart by expression

Anonymous — Wed, 01 Jun 2016 10:38:58 GMT

Hi Joan,

I have used the below expression for my below chart may be this helps..

if(ValueList ('Actual', 'Plan', 'Prev Year')= 'Actual',rgb(60,2,95),

if(ValueList ('Actual', 'Plan', 'Prev Year')= 'Plan',rgb(150,150,150),rgb(102,0,133)))

You can use your dimensions and the conditions similar to above in the colours and legends and choose

colours custom and choose by expression

topic Color bar chart by expression in App Development

Color bar chart by expression

Re: Color bar chart by expression