Graph issue, Stacked bar with secondary dimension

Mon, 03 Jan 2011 21:42:50 GMT

Hi,

I am new to Qlikview and need some help. Please see the attached image.

I would like to know if its possible to show 2 bars on my graph per month/year, one is a stacked collection of all the "Source" values apart from the "Budget" value, this i would like in a separate bar shown to the side on each month.

I have tried using multiple dimensions with IF statements to restrict the values but i just cant get it to do what i want. I also tried multiple expressions with If statements, this did not work either.

Any help that can be offered would be greatly appreciated.

Kind regards,

Dom

Graph issue, Stacked bar with secondary dimension

Tue, 04 Jan 2011 01:26:57 GMT

My best suggestion is this:

1) Under general tab, select combo chart.

2) Your only dimension should be the month field.

3) Under the expressions tab, use set analysis to hive out the various parts that you want to appear seperately, including budget.

It looks something like this:

sum({<REFERRERS.SOURCE_CODE = {'Advertisement'}>} [Member Counter])

4) Set the 'Budget' expression to display as a 'Line' only

5) set the remaining measures to display as 'Bar' only

6) Under the 'Style' tab, set subtype to 'Stacked'

It's not a 'Bar beside a bar' as you'd hoped, but it provides the same information in a very readable way. If it helps, you can also play with the line's properties in the 'expressions' tab. You can use 'plateau center' and it starts to look something a little more like a bar...

That's as close as I can get off the top of my head. Other suggestions?

topic Graph issue, Stacked bar with secondary dimension in QlikView

Graph issue, Stacked bar with secondary dimension

Graph issue, Stacked bar with secondary dimension