how to calculate

[#1]

create set analysis for sales ad profits  Previous quarter Vs Current Quarter

[swuehl]

The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.

[#3]

Hi,

I usually use attached script to create date flags, easy to use and to implement.

Create a date_flag table or use parts of the script within your existing table. When you then want to use your flags in the app all you need to do is, Sum({$<_QTD_TY={'1'}>} Sales) and for previous quarter Sum({$<_PR_QTD={'1'}>} Sales) .

Sample app: https://www.dropbox.com/sh/99ktlymtn6ni8py/NEJ0xw8GgJ

BR

Fredrik

[#4]

Good blog post swuehl but if the data-set is large, would i recommend to do some pre-calculations inside the script e.g. date-flags. Set-analysis in combination with large volumes of data can cause heavy cpu loads on the Qlikview-server.