topic Re: Cannot Link Master Calendar in Connectivity & Data Prep

Cannot Link Master Calendar

l47474747 — Thu, 23 Dec 2021 14:47:15 GMT

Dear Masters,

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:

Form id	form submission id	date submitted	Are you reporting a Surplus or Loss, please select below	Amount of the anomaly incurred?
200	116532	20/06/2019 18:28	Loss	7.75
200	116407	19/06/2019 10:27	Loss	2.88
200	116250	17/06/2019 23:46	Surplus	4.98
200	116248	17/06/2019 23:24	Loss	7.98
200	116224	17/06/2019 18:19	Surplus	4.65

This is just a snippet of each table.

Thanks,

marcus_sommer — Fri, 05 Jul 2019 12:07:44 GMT

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 — Fri, 05 Jul 2019 12:25:03 GMT

Hi Marcus,

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

Sorry about the inexperience, I am new.

marcus_sommer — Fri, 05 Jul 2019 12:30:58 GMT

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