Discussion board where members can learn more about Qlik Sense Data Connectivity.
I am having trouble implementing my 13 period calendar into Qliksense. Could you help?
This is my master calendar:
And I want to link it to this data:
This is just a snippet of each table.Thanks,
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;
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.
View solution in original post
Hi Marcus,Thanks for getting in touch. where should I input these lines of code?
Sorry about the inexperience, I am new.
NewMasterCalendar: load *, date(STARTDATE + iterno() - 1) as Datefrom YourMasterCalendar while STARTDATE + iterno() - 1 <= ENDDATE;
Submission: load *, date(floor([date submitted])) as Datefrom YourSubmissionTable;