topic Re: Adding Current year with previous year max month? in QlikView

Adding Current year with previous year max month?

Mon, 04 Aug 2014 11:18:14 GMT

Hi All,

I want to add current year 12 month with previous year max month(means 12 th month).

for ex:

i selected financial year 2015(Apr-Mar)

i want to add ---Mar-2014+currnt year all months(from Apr to Mar)

How to pick the previous year value when i selected current year.

Urgent plz help on this.

Thanks,

Ashok.

tresB — Mon, 04 Aug 2014 11:27:07 GMT

If you are having a year field, you could try like:

=Sum({<Year+={"$(Max(Year)-1)"}>} Sales)

sudeepkm — Mon, 04 Aug 2014 11:32:09 GMT

I think you can keep the value in a variable like below. and then use the variable in the expression with the rest of the current year values.

sum({<Year={"$(=Max(Year)-1)"},Months={Mar} >} Price)

// I hard coded the month value as Mar was the highest as per your business logic