Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted

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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

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

CYBenefits or
YTDBenefits or
QTDBenefits or

MTDBenefits

Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw. Is that what you want?


talk is cheap, supply exceeds demand
Highlighted

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

Highlighted
Contributor III
Contributor III

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:

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?