topic Difference between set analysis values in QlikView

Difference between set analysis values

Mon, 29 Aug 2011 18:06:47 GMT

I am trying to get the difference between two set analysis values. I need to get the variance between the actual and the forecasted values.

Actual = sum({<Date={'7/31/2011'},Forecast={Actual}>}AvgBalance)

Forecasted = sum(<Date={'7/31/2011'},Forecast={Plan}>}AvgBalance)

Is this possible, I am new to QlikView, any help would be appreciated.

Difference between set analysis values

Mon, 29 Aug 2011 19:18:38 GMT

Hello,

Looks like you are going in the right direction, except that you need to add {' '} quotes to your text values within the braces. If you want the variance between the Actual and Forecast, depending on where you are using the below expressions, you can do a simple Actual {Expression} - Forecasted {Expression} as seen below.

= sum({<Date={'7/31/2011'},Forecast={'Actual'}>}AvgBalance) - sum(<Date={'7/31/2011'},Forecast={'Plan'}>}AvgBalance)

Hope this helps.

Mady

Difference between set analysis values

Mon, 29 Aug 2011 19:31:58 GMT

Thank you. That did work. I didn't actually think you could use such a simple expression. The actual and forecasted calculations worked without the quotes, but I added them anyway.