Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Automatically Create Expressions with Point in Time Set Analysis


Automatically Create Expressions with Point in Time Set Analysis

Hi Everyone,

Here I'm bringing together a few recent blog posts from QlikCentral.com. These are:

One of the challenges I've faced is when you have a set of expression created you need to do several variations for each. One for each point in time calculation (i.e. Last Week, Last Month, Last Year, etc.). Problem is you can easily go from 50 expressions to 500 which then becomes difficult to manage and could lead to accuracy issues.

Here is the code I use to automatically take the basic expressions and create all the new variations in the script. I've given you three files but you would also need the calendar qvd output from .

The script to do this is a bit complex and I've written a breakdown of the code on my blogsite (I'll pop a link in the comments) and also on my YouTube channel.

I hope you find this useful.



Labels (2)
Version history
Revision #:
1 of 1
Last update:
‎02-24-2016 08:10 AM
Updated by: