Diff Periodic View

Sat, 25 Jul 2015 18:01:55 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,

QV User

Re: Diff Periodic View

Gysbert_Wassenaar — Mon, 27 Jul 2015 14:38:01 GMT

See attached example.