Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

Calendar using two dates coming from different table

Hello, i want to created master calendar using two dates coming from different tables

=======================================

Table 1 has the data from (2017 till 2020)

Table1:    //Photo-201701 format

LOAD Photo,
left(Photo,4) as Year,
Project as [Project Code]

From Source......

==================================

Table 2 Has data from 2017 till 2025

Table 2:

Qualify *
;
Unqualify [Project Code];
LOAD

Project as [Project Code],
[Calendar Year], //format of this feild is 201701

From Source.......]

Unqualify *;

1) I want to show the  single filter at front showing values from 2017 to 2025 (one single filter for entire dashboard).

Aspiring_Developer_1-1598695059337.png

2) if i make selection in filter (Year) as 2017 , it should get filtered in the other also ie calendar year

So far i have done below:

Table A:

Project & left(Photo) as %Key_Year

From Source...

 

Table B:

Unqualify *;

Qualify %key;

Load 

Project & [Calendar Year] as % Key_Year

From Source...

Unqualify *;

And it works 

Aspiring_Developer_2-1598695695775.png

 

But should i show the single filter at front end. Please suggest 

@jonathandienst 

 

thanks

1 Reply
sunny_talwar

Have you seen this post -> Canonical Date