Need help on dates

Sun, 26 Jul 2015 05:06:44 GMT

Hi All,

Greetings for the day.

I have one requirement in my dashboard. I have four buttons YTD, Full years, Pyear,Quarter.

I need to display different data for these buttons in different tables. Below is the description.

Actually my fiscal year starts from November.

YTD - If i click on this button it sholud disply data for all completed quarters for current year and last 2 years.

Ex : If we are in second month of third quarter then it should display data for First two quarters of current year and same for last two years.

Full Years - It should display data only for completed years i.e not present year (we are in 2015 Q3 then it should display data for 2014,2013).

PYear - If we enter into second half of the year then it should display data for first 6 months of current year as well as previous 2 years.

Quarter - It should display data for last 9 quarters but not current Quarter

From last 2 days i'm trying to find the solution using set analysis but i am unable to find exact solution.

I have attached sample QVW also.

Thanks

topic Need help on dates in QlikView