topic Get Multiple Previous Years with Set Expression in QlikView

Get Multiple Previous Years with Set Expression

Mon, 14 Jan 2013 15:33:15 GMT

Hi,

I have a report with a simple List Chart that sums Net Value. I also have Calendar_Year as a field, so that multiple years can be selected. And I have this expression to calculate the previous selected year:

sum({$<Calendar_Year={"$(=ONLY(Calendar_Year)-1)"}>} DocumentRows.LineTotal)

But this won't work when multiple years are selected.

Do you know a way to calculate the sum of the previous years when multiple years are selected?

Kind Regards

Julian

Re: Get Multiple Previous Years with Set Expression

Mon, 14 Jan 2013 15:39:18 GMT

Hi Julian,

You can use this:

sum({$<Calendar_Year={"$(=max(Calendar_Year)-1)"}>} DocumentRows.LineTotal)

or if you want the sum of all previous years try this:

sum({$<Calendar_Year={"<=$(=max(Calendar_Year)-1)>=$(=min(Calendar_Year)-1)"}>} DocumentRows.LineTotal)

Hope this helps

Regards!

Re: Get Multiple Previous Years with Set Expression

Mon, 14 Jan 2013 15:44:03 GMT

Thanks a lot Gabriela!

What I was looking for was your second anwer and it works like a charm!!

Kind Regards