Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
l47474747
Contributor
Contributor

Cannot Link Master Calendar

Dear Masters,

I am having trouble implementing my 13 period calendar into Qliksense. Could you help?

This is my master calendar:

YEARPERIODSTARTDATEENDDATEPAYPERIODPAYDATEPAYSTARTPAYENDNo DaysReport Against
2006108/01/200604/02/20064410/02/200608/01/200604/02/200628C
2006205/02/200604/03/20064810/03/200605/02/200604/03/200628C
2006305/03/200631/03/20065207/04/200605/03/200601/04/200627C
2006401/04/200629/04/2006405/05/200602/04/200629/04/200629F1
2006530/04/200627/05/2006802/06/200630/04/200627/05/200628F1
2006628/05/200624/06/20061230/06/200628/05/200624/06/200628F1
2006725/06/200622/07/20061628/07/200625/06/200622/07/200628F2
2006823/07/200619/08/20062025/08/200623/07/200619/08/200628F2
2006920/08/200616/09/20062422/09/200620/08/200616/09/200628F2
20061017/09/200614/10/20062820/10/200617/09/200614/10/200628F3
20061115/10/200611/11/20063217/11/200615/10/200611/11/200628F3
20061212/11/200609/12/20063615/12/200612/11/200609/12/200628F3
20061310/12/200606/01/20074012/01/200710/12/200606/01/200728F3

 

And I want to link it to this data:

Form idform submission iddate submittedAre you reporting a Surplus or Loss, please select belowAmount of the anomaly incurred?
20011653220/06/2019 18:28Loss7.75
20011640719/06/2019 10:27Loss2.88
20011625017/06/2019 23:46Surplus4.98
20011624817/06/2019 23:24Loss7.98
20011622417/06/2019 18:19Surplus4.65

 

This is just a snippet of each table.

Thanks,

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

It's not really a master-calendar but it could be used to create one, for example with:

cal: load *, date(STARTDATE + iterno() - 1) as Date from A while STARTDATE + iterno() - 1 <= ENDDATE;

and with:

date(floor([date submitted])) as Date

you creates a real date within your fact-table and both tables would be linked over this new field Date.

- Marcus

View solution in original post

3 Replies
marcus_sommer

It's not really a master-calendar but it could be used to create one, for example with:

cal: load *, date(STARTDATE + iterno() - 1) as Date from A while STARTDATE + iterno() - 1 <= ENDDATE;

and with:

date(floor([date submitted])) as Date

you creates a real date within your fact-table and both tables would be linked over this new field Date.

- Marcus

l47474747
Contributor
Contributor
Author

Hi Marcus,

Thanks for getting in touch. where should I input these lines of code?

Sorry about the inexperience, I am new.

marcus_sommer

It's just:

NewMasterCalendar: load *, date(STARTDATE + iterno() - 1) as Date
from YourMasterCalendar while STARTDATE + iterno() - 1 <= ENDDATE;

Submission: load *, date(floor([date submitted])) as Date
from YourSubmissionTable;

- Marcus