Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this:
There are pros and cons if you want to do it like this and you should be aware of them, have a look at:
Why You sometimes should Load a Master Table several times
Re: Tutorial - Using Common Date Dimensions and Shared Calendars
Hi Sasi Kumar,
PFA
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.
Hi,
I use the canonical date approach in this situation.
Mark
Thanks a lot for your valued solutions. Really helpful