topic How to set a dimension value in an expression. in QlikView

How to set a dimension value in an expression.

Mon, 03 Aug 2009 12:42:07 GMT

I have a gauge that show the actual income as a percent of budgeted income. This should display the result for the user's selection of period and department. However I always want to show Income. So if the user has selected 'Fin Stmt Section' to be 'Expenses', I want the expression to overide this setting. ie set 'Fin Stmt Section' to be 'Income'.

The following doesn't really work: if("Fin Stmt Section" = 'Income', Sum(Actual$)/Sum (Budget$),0)

as it gives the correct result if the user selected 'income' otherwise is shows zero.

Thanks for your help..

Derek

How to set a dimension value in an expression.

Mon, 03 Aug 2009 13:16:02 GMT

Hi Derek,

If you got an field name with spaces in it, use the [ ] brackets

try using Set analysis:


Sum({$ <[Fin Stmt Section]={"Income"}>} Actual$) / Sum({$ <[Fin Stmt Section]={"Income"}>} Budget$)
This should do the trick

How to set a dimension value in an expression.

Tue, 04 Aug 2009 07:11:16 GMT

Thanks Rey-man - that worked and I've learned something new.