Variance based on selected option in Group

Fri, 28 Nov 2014 09:18:05 GMT

I have three columns, Actual, Budget, and Variance

The variance is:

1) Actual-Budget and Actual-Budget/Budget

These two variance are grouped together (toggle) to switch between value and percentage (%).

I want to add in a fourth column called Forecast. I want to group Forecast with Budget

So in essence, my columns would be Actual, Budget/Forecast and Variance.

My requirement is for the Variance column to calculate based on which is chosen between Budget and Forecast.

Is this possible?

Any help would be appreciated.

Regards,

Magen

Re: Variance based on selected option in Group

Gysbert_Wassenaar — Fri, 28 Nov 2014 10:17:59 GMT

These two variance are grouped together (toggle)

If that's done with an expression group then I don't think it's possible. I'd use separate expressions and the conditional display option of the expressions to show/hide the required columns as needed. A button or text object could be used to toggle between the two options using a Set Variable action and a variable. If you create a variable vToggle and give it the initial value 0 then the Set Variable action should set the vToggle variable to the value =NOT vToggle. Likewise the conditional display expressions are either =vToggle or =NOT vToggle.

topic Variance based on selected option in Group in QlikView

Variance based on selected option in Group

Re: Variance based on selected option in Group