topic Color Expression for stacked bar graph not working in QlikView

Color Expression for stacked bar graph not working

Fri, 12 Jun 2015 15:26:48 GMT

I have an issues apply colors correctly to a stacked bar chart

I always want to show 2 years of data, I get that done

I want to apply colors based on a field, that works when ... either everything is selected or nothing is selected

I've attached a file to show what I mean

swuehl — Fri, 12 Jun 2015 15:34:27 GMT

Maybe like

only({1}

IF(group = 'A',RGB(84,130,53),

IF(group = 'B', RGB(101,156,64),

IF(group = 'C', RGB(121,187,76),

IF(group = 'D', RGB(145,224,92)))))

)

Fri, 12 Jun 2015 15:47:59 GMT

That did the trick.

Can you maybe expand on the use of that ONLY({1} )??

I'm new to qlik and not familiar with it's uses

swuehl — Fri, 12 Jun 2015 15:52:58 GMT

The set expression (have a look at chapter 'set analysis' in the Help) with set identifier 1

{1} is forcing QV to ignore all user selections for that aggregation.

You can use set expressions only within aggregation functions like sum(), count(), and yes, only().

Fri, 12 Jun 2015 15:56:36 GMT

Ok, so I get the set analysis part of {1} to ignore all selections. I guess I'm not familiar with the aggregation is only()