Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Time Periods with different dates - how?


I have a tricky one. I got two KPIs lets say "sales" and "accidents". I have defined 4 time periods "current", "before", "previous" and "year on year". And i have data per calendar week.

Now the definition of what is current, before and so on can change.

For "sales" Current is:

CW15 - 2016

CW16 - 2016

and for "accidents" Current is:

CW16 - 2016

CW17 - 2016

same for the other pediods in the past - e.g.:

For "sales" previous is:

CW01 - 2016

CW02 - 2016

and for "accidents" previous is:

CW02 - 2016

CW03 - 2016

In the Dashboard I want obviously only show one listbox where the user can select a time period as filter option.

How do i do this?

Before i had multiple values for multiple time perdiods i just had a mapping table (see below)

Now how could i do this? Adjusting calculation formulars by set analysis would not be an issue

CW15 - 2016Current
CW16 - 2016Current
CW01 - 2016Previous
0 Replies