While extracting from the DB created the View to generate all the measures based on these derived the appropriate MTD,QTD,YTD for respective Measures.
There is no Calander created in QV but it;s all maintained in DB level and derived the respective Month,Year,QTD,YTD Measures,...
How to put in set analysis based on the selectoions of text Box respective aggregations need to happen?
All the chart expressions need to be in Text Boxes.
Please find the attached QVW.
Appricaite your help.Thanks.
The CY, xTD values are all fields of their own so all you need to do is sum then (or average them if you need averages). Just like you already have in the text boxes.
I already derived the YTD,QTD,MTD,Current Year in the Data Base it self as each in individual Measure as below:
Benefits(Measure)is extracted as below in DB.My Issue is on selection of the Text Box as YTD,QTD,MTD the set analysis expression need to change as per the selection.
Please help on the Set analysis Expression.
Sunny your solution is working with sample set of data but not working with the Actual data set
While giving Variable vVar1 in Text Objects and providing the equivalent Set Expression but Throwing error as above: