Actual Value Month wise

sona_sa — Wed, 30 Jul 2014 07:09:02 GMT

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).

Expression = (sum( {1<Year=,month>} CTS )-Above(Sum({1<Year=,month>} CTS)))/Above(Sum({1 <Year=,month>} CTS))*100

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. Now I have to show the graph on the drilldown of year wise ---> Month Wise.

But for the same graph Month value is coming same.

Please find the attached qvw for the same.

Thanks.

Re: Actual Value Month wise

marcus_sommer — Wed, 30 Jul 2014 10:12:32 GMT

I'm not absolutely sure but I think there isn't a way to show this with one expression. The common approach to compare different time-periods in a single object is to use several expressions (instead time-periods as dimension) like these:

sum({< Year = {$(=max(Year))} > } Value) // current

sum({< Year = {$(=max(Year)-1)} > } Value) // previous

sum({< Year = {$(=max(Year))} > } Value) - sum({< Year = {$(=max(Year)-1)} > } Value) // deviation

- Marcus

topic Actual Value Month wise in QlikView

Actual Value Month wise

Re: Actual Value Month wise