Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Multiple Time Periods with different dates - how?

Hi,

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

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