topic Re: Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis in QlikView

Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis

Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I need to create a stacked bar chart that shows in X axis the previous and the current selections and the sum of the values of each product in Y axis. Attached are the qlikview file with my data and an example of the chart I want to create.

I also would like to know if it is possible to show the value of the selecions (Month 01, Month 02, Month 03) instead of "Previous" and "Current".

Thanks!!!

Re: Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis

Gysbert_Wassenaar — Mon, 16 May 2016 05:49:41 GMT

You can do it if you add a calculated dimension and replace both expressions with one expression. The calculated dimension you need to add is =ValueList('Previous Selection','Current Selection'). This must be the first dimension in the chart so promote it to the top spot. The single expression you need to use is this one:

if(ValueList('Previous Selection','Current Selection')='Current Selection',

SUM(Value),

SUM({$1}Value)

)

Remove any other expressions.

Re: Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis

Anonymous — Mon, 16 May 2016 06:27:07 GMT

just added touch up to Gysbert suggestion.Hope this serves your requirement.

Please find the attached qvw

Re: Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis

Mon, 16 May 2016 13:49:11 GMT

Thank you very much!!! It is exactly what I need.

Re: Stacked Bar Chart - Set Analysis Previous And Current Selecions in X Axis

Mon, 16 May 2016 13:49:20 GMT

Thank you very much!!! It is exactly what I need.