Set analysis expression based on variable value

Sun, 29 Mar 2015 23:49:27 GMT

I'm using QlikView Components to generate a master calendar table and set analysis variables. This allows me to easily create expressions for the current year to date and comparisons to the previous year. For example:

Total amount in year to date: Sum($(vSetYTD) Amount)

Total amount in the previous year to date: Sum($(vSetPreviousYearYTD) Amount)

My next goal is to provide the ability to select the period used in the set analysis.

To do this I have created three text area objects, which set a variable vSetPeriodSelection to 'YTD', 'MTD', and 'QTD' respectively.

I've tried expressions such as Sum($(IF(vSetPeriodSelection = 'YTD', vSetYTD, IF(vSetPeriodSelection = 'QTD', vSetQTD, vSetMTD))) Amount) without any success.

So my question is how do I use the value of this variable to determine the variable used in the set expression?

thanks

topic Set analysis expression based on variable value in QlikView

Set analysis expression based on variable value