Issues facing with the Set Analysis Point in Time Anlysis of YTD,QTD,MTD

[Anonymous]

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.

[Gysbert_Wassenaar]

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.

[sunny_talwar]

I am not sure I understand your requirement? What exactly are you looking to achieve?

[Anonymous]

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.

CYBenefits

YTDBenefits

QTDBenefits

MTDBenefits

[Anonymous]

=NUM(sum({<Option={'GA'}, [LOCATION]={'USA'}>}CYBenefits),'$#,##0.00')

CYBenefits or YTDBenefits or

QTDBenefits or

MTDBenefits

[Gysbert_Wassenaar]

See attached qvw. Is that what you want?

[sunny_talwar · Accepted solution]

Check out the attached:

Expression:

=NUM(sum({<Option={'GA'}, [LOCATION]={'USA'}>}$(vVar1)Benefits),'$#,##0.00')

Where vVar1 is set by the button object using actions.

[Anonymous]

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:

[sunny_talwar]

It would show you error in expression editor window, but should still work. Have you tried pressing okay to check if it is working or not?