Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to connect my Inline Table with Master Calendar

Hi I'm trying to figure out how to link my inline table with master calendar. On general tutorials it shows how to implement master calendar to a linked table sourced through an excel file. But since I have an inline table, I'm having trouble to tie both the table and the master calendar table together. Any help would be greatly appreciated.

 

Inline Table

Table2:

LOAD *,

'Q' & ceil(month(AddMonths(Date(COB_Date2),-10))/3) AS Fiscal_Quarter

 

Inline [

COB_Date2, Sales

01/01/2018, 20

02/01/2018, 30

03/01/2018, 68

04/01/2019, 25

05/01/2018, 65

06/01/2020, 75

07/01/2020, 25

08/01/2018, 98]

 

Incorrect attempt at linking

MasterCalendarTable:

Load * Resident Table2;

Load
max(COB_Date2) as MaxDate,

min(COB_Date2) as MinDate,

Resident Table2;

Labels (1)
0 Replies