topic YTD stacked bar in QlikView

YTD stacked bar

Fri, 28 Dec 2012 15:28:04 GMT

Hi,

I am creating a bar chart with no dimension.

So i have 3 expressions to make 3 bars:

Sales for current month
Year to date sales.
Last year to date sales

Next, i'd like to make them as stack-bar, so i can have segments of says- product type in each bar.

But i'm stuck here...

Re: YTD stacked bar

Gysbert_Wassenaar — Fri, 28 Dec 2012 16:06:50 GMT

See attached qvw. I use a valuelist to create a calculate dimension with a value for the three different expression. The actual expression is a nested if that uses the value from the valuelist. The Product dimension is used the stack segments.

edit: updated the qvw to add a chart with an ascending sort on the second dimension to sort the stack.

Re: YTD stacked bar

Fri, 28 Dec 2012 16:17:42 GMT

Hi Gysbert ,

Thanks ! smart solution.

Just another question, is there a way i could sort the stack ascending?