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: 
spcon2016
Partner
Partner

Match single dates to master calendar

Hi community, 

I'd like to use 2 tables in my datamodel, but I'm facing with a known issue:

ProductionStatus: 

load * inline [

date, status

01.01.2020, 1

05.01.2020,2

24.01.2020,3

];

MasterCalendar:

load * inline [

date,month,day

01.01.2020,1,1

02.01.2020,1,2

03.01.2020,1,3

[...]

31.01.2020,1,31

];

Well, my first idea was to create an additional column within my ProductionStatus table to build a rdate range and use intervalmatch as described here

Is this approach the only way or is it possible without creating an additional column? 

Labels (1)
1 Reply
fosuzuki
Partner
Partner

What is the desired output? To have the ProductionStatus table with all dates and the status up to that date? Like:

date, status

01.01.2020, 1

02.01.2020, 1

03.01.2020, 1

04.01.2020, 1

05.01.2020,2

06.01.2020,2

...

23.01.2020,2

24.01.2020,3

25.01.2020,3

26.01.2020,3

...