Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Global Calendar Accross All tables in Qliksense

Hi Saima,

You can create canonical calendar in such cases.

Refer link: Canonical Date

Regards,

Pankaj

joydipp1988
Not applicable

Re: Global Calendar Accross All tables in Qliksense

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

Re: Global Calendar Accross All tables in Qliksense

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
spayamir
Not applicable

Re: Global Calendar Accross All tables in Qliksense

May be this can help you: Canonical Date