Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to calculate

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

3 Replies
MVP
MVP

Re: how to calculate

Not applicable

Re: how to calculate

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

Re: how to calculate

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.

Community Browser