topic Set Analysis on past year total in QlikView

Set Analysis on past year total

Sat, 05 Oct 2013 20:03:10 GMT

Dear Community,

I need help on syntax in expression. I have the total sales with the dimension by year, however, I don't know how to write the syntax which the total amount of current year divides by last year total sales of sum of 2 products.

See whether anyone could help, I really appreciate on this.

Thanks.

Re: Set Analysis on past year total

Gysbert_Wassenaar — Sun, 06 Oct 2013 16:27:40 GMT

If you're using year as a dimension then set analysis won't work. Try using the above() function or an AsOf table. See this document: Calculating rolling n-period totals, averages or other aggregations

Re: Set Analysis on past year total

Mon, 07 Oct 2013 09:54:53 GMT

Hi,

PFA ,

Hope it helps you