Actual vs Actual

[sona_sa]

Hi,

I have three years actual data. I want actual vs actual on the behalf of this expression - (Sum(Current Year Actual Value) - Sum(Previous Year Actual Value)) / Sum(Previous Year Actual Value).

But I am getting only one year. i.e - 2013. In this Case - It should be 2014 and 2013.

For 2014 - Negative (-74.73) and For 2013 = +34.53.

Please find the attached qvw for the same.

Thanks.

[simenkg]

Hi, Akumar.

In QlikView you cannot specify the year in Set analysis if you are using Year as dimension in your Chart.

Your expression works if you just want to see the change for one year, simply remove the Year Dimension.

If you wish to show the change over time you can use an expression like this, with Year as Dimension:

(sum(CTS)-above(sum(CTS)))/Above(Sum(CTS))

Hope this helps.

Regards
SKG

[MK_QSL]

You are getting only one year data because your max(year) is only calculated once in set analysis.

[sona_sa]

Thanks for reply. This is working, But whenever I am selecting the Year, The chart is not displaying any value. Also for month, Jan month is not coming.

Thanks.