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

Master Calendar Date from Multiple dates in dataset

Dear QVExperts,

I have multiple dates in my table, which all show in the Charts.

List box to be created for Year, Month, Quarter.

Selecting those list boxes should impact in all the date columns. Can anyone please suggest me on this.

Thanks,

Sasi

6 Replies
ecolomer
Master II
Master II

swuehl
MVP
MVP

There are pros and cons if you want to do it like this and you should be aware of them, have a look at:

Canonical Date

Why You sometimes should Load a Master Table several times

Re: Tutorial - Using Common Date Dimensions and Shared Calendars

raju_insights
Partner - Creator III
Partner - Creator III

Hi Sasi Kumar,

PFA

effinty2112
Master
Master

Hi Sasi,

                    I hope this is relevant to your situation. I have many apps with multiple calendars, for example see this extract from the Table Viewer.

Multiple Calendars.jpg

You don't need sheet objects for each calendar you need to select one calendar at one time.

Here is an inline table I use:

[Date Dimensions]:

LOAD * INLINE [

    %Datum, eQtr, eMonth, eWeek,eYear,vDateDim,PeriodID

    Entry, EntryQuarter, EntryMonth, EntryWeek, EntryYear, ORDER_ENTRY_DATE,EntryPeriodID

    Invoice, InvQuarter, InvMonth, InvWeek, InvYear, INVOICE_DATE,InvPeriodID

    Due, DueQuarter, DueMonth, DueWeek, DueYear, DUE_DATE,DuePeriodID

];

Make a listbox for the field %Datum and make it "Always One Selected Value". If you make a listbox for Year you don't have it select on one field you have it work on the expression '=$(=eYear)' and similarly for the other calendar fields.

I have another "Always One Selected Value" listbox containing 'W','M'','Q','Y' and in combination with the choice of calendar this table picks the correct chart dimension on the x axis for time dependent charts.

%Datum Period ChartTimeDimension
DueWDueWeekBeg
EntryWEntryWeekBeg
InvoiceWInvWeekBeg
DueMDueMPeriod
EntryMEntryMPeriod
InvoiceMInvMPeriod
DueQDueQPeriod
EntryQEntryQPeriod
InvoiceQInvQPeriod
DueYDueYear
EntryYEntryYear
InvoiceYInvYear

Hope this was relevant to your problem and helpful.

Mark_Little
Luminary
Luminary

Hi,

I use the canonical date approach in this situation.

Mark

Not applicable
Author

Thanks a lot for your valued solutions. Really helpful