Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramrongala
Contributor II
Contributor II

How to link/assosiation user defined dates table to master calendar.

HI experts,

below is the user defined table(dates maybe changed by the user in often)

Period IDCalculation StartCalculation EndSend DateEffected Date
0011/1/20213/31/20214/15/20215/1/2021
0024/1/20216/30/20217/15/20218/1/2021
0037/1/20219/30/202110/15/202111/1/2021
00410/1/202112/31/20211/15/20222/1/2022

 

I have master calendar also, how can I link to master calendar.

user wants the filter(period)  to be like combination of 3 columns (P4PPeriodID-KPICalculationStart-KPICalculationStart)

ramrongala_0-1626885061552.png

now if user selects 1st value(001-01/01/2021-31/03/2021) then show the dates from 01/01/2021to 31/03/2021 in dashboard

if user selects 2nd value(001-04/01/2021-30/06/2021) then show the dates from 04/01/2021 to30/06/2021 in dashboard

please help me how to achieve this one.

 

1 Reply
JuanGerardo
Partner
Partner

Hi @ramrongala, I think you can use a link table between periods and calendar dates, so you have all dates for every period, and if you select a period you will associate with corresponding dates in calendar. An example:

Calendar
--------
Date
1/1/2021
2/1/2021
3/1/2021

Link Table
------------------------------------
Period                    | Date
From 1/1/2021 To 2/1/2021 | 1/1/2021
From 1/1/2021 To 2/1/2021 | 2/1/2021
From 2/1/2021 To 3/1/2021 | 2/1/2021
From 2/1/2021 To 3/1/2021 | 3/1/2021

JG