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

[#1]

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!!!

[Gysbert_Wassenaar · Accepted solution]

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.

[Anonymous]

Hi

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

Please find the attached qvw

[#4]

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

[#5]

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