Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
create set analysis for sales ad profits Previous quarter Vs Current Quarter
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
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.