Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

8 Replies
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.


talk is cheap, supply exceeds demand
sunny_talwar

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

Anonymous
Not applicable
Author

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
Not applicable
Author

=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?


talk is cheap, supply exceeds demand
sunny_talwar

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
Not applicable
Author

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?