topic Re: Stacked bar chart color coding in QlikView

Stacked bar chart color coding

Anonymous — Thu, 27 Apr 2017 19:31:29 GMT

Hi all,

I am using a stacked bar chart using 2 dimensions and 1 expression

The Dimensions are

=Left(MileStoneCategory,1)&Right(MileStoneCategory,1)

MileStoneStatus_FILTER

The Expression is

=NUM((Count(MileStoneStatus)/Count(Total {<MileStoneCategory={'Milestone1'}>} MileStoneStatus)),'##.00')

MileStoneCategory field has the values - Milestone 1, Milestone 2,Milestone 3,Milestone 4,Milestone 5,Milestone 6

MileStoneStatus field has the values which are color coded for the stacked bar chart -->

Completed (black)

Partial (blue)

Not Complete (green)

Not Met (grey)

Not Applicable (light grey)

The order of each bar must be like the above according to data.

In the Sort tab, it is sorted to the MileStoneStatus dimension by Ascending in Expression -->

=Only({1}IF(MileStoneStatus = 'Not Applicable', 1,

IF(MileStoneStatus = 'Not Met', 2,

IF(MileStoneStatus = 'Not Complete', 3,

IF(MileStoneStatus = 'Partial', 4,

IF(MileStoneStatus = 'Complete', 5,

))))))

Re: Stacked bar chart color coding

sunny_talwar — Thu, 27 Apr 2017 19:36:51 GMT

Does the sort change based on selection?

Re: Stacked bar chart color coding

Anonymous — Thu, 27 Apr 2017 20:06:31 GMT

no, the sort stays the same. Only the size of the section in the bar will change

Re: Stacked bar chart color coding

sunny_talwar — Thu, 27 Apr 2017 20:09:59 GMT

but what is the issue? Sort changing or value changing?

Re: Stacked bar chart color coding

Anonymous — Thu, 27 Apr 2017 20:16:35 GMT

The issue is that the sorting of the color is changing. It is suppose to stay in the same order. Top of the bar is Not Applicable - light grey, then grey, green, blue and bottom of the bar is Complete - Black. Like it shows in the legend

Re: Stacked bar chart color coding

sunny_talwar — Thu, 27 Apr 2017 20:19:20 GMT

Not sure if it makes a difference, but try this

=Match(Only({1} MileStoneStatus), 'Not Applicable', 'Not Met', 'Not Complete', 'Partial', 'Complete')

Re: Stacked bar chart color coding

Anonymous — Fri, 28 Apr 2017 00:11:50 GMT

I tried that option. It din't make a difference. I tried using the Background Color of the field. Any ideas on that?