topic Re: Issues facing with the Set Analysis Point in Time Anlysis of YTD,QTD,MTD in QlikView

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

Anonymous — Mon, 11 Apr 2016 12:12:29 GMT

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.

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

Gysbert_Wassenaar — Mon, 11 Apr 2016 12:26:40 GMT

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.

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

sunny_talwar — Mon, 11 Apr 2016 12:27:42 GMT

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

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

Anonymous — Mon, 11 Apr 2016 12:35:32 GMT

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

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

Anonymous — Mon, 11 Apr 2016 12:37:04 GMT

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

CYBenefits or
YTDBenefits or

QTDBenefits or

MTDBenefits

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

Gysbert_Wassenaar — Mon, 11 Apr 2016 12:39:06 GMT

See attached qvw. Is that what you want?

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

sunny_talwar — Mon, 11 Apr 2016 12:40:37 GMT

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.

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

Anonymous — Mon, 11 Apr 2016 15:34:46 GMT

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:

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

sunny_talwar — Mon, 11 Apr 2016 15:55:03 GMT

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?