topic Re: Master Calendar Date from Multiple dates in dataset in QlikView

Master Calendar Date from Multiple dates in dataset

Sat, 21 Nov 2015 09:42:53 GMT

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

Re: Master Calendar Date from Multiple dates in dataset

ecolomer — Sat, 21 Nov 2015 09:47:08 GMT

See this:

Master Calendar Data

Re: Master Calendar Date from Multiple dates in dataset

swuehl — Sat, 21 Nov 2015 09:50:49 GMT

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

Re: Master Calendar Date from Multiple dates in dataset

rajuamet — Sat, 21 Nov 2015 11:02:21 GMT

Hi Sasi Kumar,

PFA

Re: Master Calendar Date from Multiple dates in dataset

effinty2112 — Sat, 21 Nov 2015 13:34:31 GMT

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.

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
Due	W	DueWeekBeg
Entry	W	EntryWeekBeg
Invoice	W	InvWeekBeg
Due	M	DueMPeriod
Entry	M	EntryMPeriod
Invoice	M	InvMPeriod
Due	Q	DueQPeriod
Entry	Q	EntryQPeriod
Invoice	Q	InvQPeriod
Due	Y	DueYear
Entry	Y	EntryYear
Invoice	Y	InvYear

Hope this was relevant to your problem and helpful.

Re: Master Calendar Date from Multiple dates in dataset

Mark_Little — Sat, 21 Nov 2015 16:35:30 GMT

Hi,

I use the canonical date approach in this situation.

Mark

Re: Master Calendar Date from Multiple dates in dataset

Mon, 23 Nov 2015 13:35:49 GMT

Thanks a lot for your valued solutions. Really helpful