topic Re: Change bar colour based on another dimension in QlikView

Change bar colour based on another dimension

alvaprajna — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have following data,

Country,entity,class,score

Austria,1523,HIGH,5

Austria,1524,LOW,3

Bang,123,High,2

Bang,1234,Low,2

Denmark,1236,Medium,2

I have a bar chart with a drill down (country--> entity) as dimension and expression=max(Score)

I need to plot this in such a way that y-axis height is max score and bar color is based on class.

if(class=HIGH,red(),class=LOW,yellow()).

if the score is same then it must consider highest class,so in above case it can be high for country=Bang.

Kindly suggest.

I tried adding background expression as if(class=HIGH,red(),class=LOW,yellow()).The value for country is not shown as 5 since it has two values

Re: Change bar colour based on another dimension

sunny_talwar — Fri, 07 Apr 2017 14:27:03 GMT

May be this

If(FirstSortedValue(class, -Score) = 'HIGH', Red(),

If(FirstSortedValue(class, -Score) = 'LOW', Yellow()))

Re: Change bar colour based on another dimension

alvaprajna — Sun, 09 Apr 2017 11:24:06 GMT

it may not be the first value always..if we have same score and the class is high and low then it should consider high,

if its low and medium then it should consider medium.if its low and high then it should high.

Re: Change bar colour based on another dimension

alvaprajna — Sun, 09 Apr 2017 11:31:27 GMT

Okay i used a table adding risk value its working now.

one more isssue, Actually in dimension..i added

=if(TotalScore=aggr(max(TotalScore),[country]) ,[country],[entity])

so that it shows me all country with highest score in bar chart. and accordigly em getting colour based on class.

But noe i am facing a new issue,If the ountry has same score its giving the highest score..but colour is not set based on the class.May be due to common score its not able to decide the class.

Ex:

Country,entity,class,score

Poland,159,HIGH,3

Poland,158,LOW,3

its basically a drill down for ex: country--> entity.

Re: Change bar colour based on another dimension

alvaprajna — Sun, 09 Apr 2017 12:44:14 GMT

In case the score is same its failing.

Re: Change bar colour based on another dimension

sunny_talwar — Sun, 09 Apr 2017 12:51:46 GMT

Would you be able to share a sample to take a deeper look at this?