Colorcoding cells with multiple values

nicolai_moller — Mon, 27 May 2013 10:14:34 GMT

I have a situation with colorcoded cells, where I want to color the cell of activitities depending on the status of the activity.

Each activity is related to a case, where a case can have multiple activities and multiple of the same activity.

In the attached document, case 1 have activity A two times, but with different status (postponed and done).

But neither of them receives a color in the chart, so it looks like none of the activities exists.

Shouldn't at least one of the colors show up in the chart, or do any of you have a another solution to this.

Thanks.

Re: Colorcoding cells with multiple values

Gysbert_Wassenaar — Mon, 27 May 2013 11:26:44 GMT

You'll have to use an aggregation function. For example

if(max(Status_Flg) = 1, blue(),

if(max(Status_Flg) = 2, green(),

if(max(Status_Flg) = 3, yellow(),

if(max(Status_Flg) = 4, brown(),

if(max(Status_Flg) = 5, black(),

if(max(Status_Flg) = 6, rgb(192,192,192)))))))

Otherwise the only() function is used and that will return a null if there is more than one value for the combination of dimensions. This is the case for Case 1 - Activity A.

topic Colorcoding cells with multiple values in QlikView

Colorcoding cells with multiple values

Re: Colorcoding cells with multiple values