Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Iterate through Date Values

I need to determine the difference between Report Date and Begin Date for every possible combination of Report and Begin Dates. Based on the result I will create a dimension field that identifies the difference in each row as either greater than or less than 90.

How do I script this in the load statement to create the Desired Results Table shown below?

 
 
 

 

SSS screenshot.png

 

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

[TempDates]:

LOAD ReportDate

FROM Table1;

JOIN

LOAD BeginDate

FROM Table2;

Because there are no matching fields to join you will get a cartesean product.

[FinalDates]:

LOAD

ReportDate, BeginDate, ReportDate-BeginDate as BucketDim

RESIDENT [TempDates];

DROP TABLE [TempDates];

 

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

[TempDates]:

LOAD ReportDate

FROM Table1;

JOIN

LOAD BeginDate

FROM Table2;

Because there are no matching fields to join you will get a cartesean product.

[FinalDates]:

LOAD

ReportDate, BeginDate, ReportDate-BeginDate as BucketDim

RESIDENT [TempDates];

DROP TABLE [TempDates];

 

View solution in original post

Highlighted
Contributor II
Contributor II

Thank you very much! This worked perfectly.