Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
In the attached file, when I select Year, then select several Months. After that, I want that when selecting Quarter, Month selection to be released and Year still be selected.
Following are the operating steps:
1. Year '2009'; 2. Month 'Feb, Jan, Jul, Jun'; 3. Quarter 'Q2'; Then "Jun' in Month to be green. Just like what is shown in "Kinepolis%20DashBoards[1].qvw" ;
What I want is when doing step 3, the Month List Box to show the related 3 months, not just 'Jun'. Just like what is shown in "year_test.bmp" ;
Thanks so much!
Jane
Hello Jane,
That is the usual behaviour for Master Calendar. I will only show Jun as there is only in Jun in the second quarter when you have related facts. Anyway you can create a macro where you set that "when selecting quarter, show me all possible values, not those who have values". If you insert into your data sources one fact with date in April, April will be selected as well.
For that, you may have two different calendars, or one not related with your fact table dates (not an actual Master Calendar)
Hello Jane, As Miguel suggested, you need to create another calendar table which is made of all dates from yyyy- ?? to today.
This calendat will then be used to display the data you're looking for.
Months are missing because they are not in your db
Hello Jane,
Not knowing the file you mention, there is a checkbox in any listbox / Properties / General that nevertheless could be of your interest. Check "Show Optional Values" (or something very similar) to show all possible months corresponding to the quarter you have selected, regardless the information they contain, if any.