Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate

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

3 Replies
Not applicable
Author

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

Not applicable
Author

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.