Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Global Calendar Accross All tables in Qliksense

Dear All,

I have 4 tables in my QlikSense App. each table has own fields as Year, Quarter , Month.

I want to use global year/quarter/month for all four tables rather than using each one individually for slicing and dicing on dashboard. Is there any way to get this done? Thanks

4 Replies
passionate
Specialist
Specialist

Hi Saima,

You can create canonical calendar in such cases.

Refer link: Canonical Date

Regards,

Pankaj

joydipp1988
Creator
Creator

Hi Saima,

Is there any date field available in those tables? Can you provide any sample data?

How much I understand to get a global calendar you need to use Canonical date situation. You need to create a Link table containing all dates from all tables. This Link table will be used to generate global Calendar. Below is a probable structure-

Canonical Date Model.PNG

Hope that helps.

Thanks,

Joy

Not applicable
Author

Thanks for your response. I do not have full date. only year, month and quarter information in each table

below is the sample data table 1 all other are same

Table-1

   

YearQuarterMonthCotactsResponses
FY-2015/16Q1April921
FY-2015/16Q1May914
FY-2015/16Q1June914
FY-2015/16Q2July914
FY-2015/16Q2August821
FY-2015/16Q2September921
FY-2015/16Q3October421
FY-2015/16Q3November47
FY-2015/16Q3December40
FY-2015/16Q4January127
Anonymous
Not applicable
Author

May be this can help you: Canonical Date