Global Calendar Accross All tables in Qliksense

[#1]

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

[passionate]

Hi Saima,

You can create canonical calendar in such cases.

Refer link: Canonical Date

Regards,

Pankaj

[joydipp1988]

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-

Hope that helps.

Thanks,

Joy

[#4]

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

Year	Quarter	Month	Cotacts	Responses
FY-2015/16	Q1	April	9	21
FY-2015/16	Q1	May	9	14
FY-2015/16	Q1	June	9	14
FY-2015/16	Q2	July	9	14
FY-2015/16	Q2	August	8	21
FY-2015/16	Q2	September	9	21
FY-2015/16	Q3	October	4	21
FY-2015/16	Q3	November	4	7
FY-2015/16	Q3	December	4	0
FY-2015/16	Q4	January	12	7

[Anonymous]

May be this can help you: Canonical Date