topic Re: Need help in writing expression. in QlikView

Need help in writing expression.

suvechha_b — Wed, 11 Jun 2014 08:24:56 GMT

Help me in writing the following expression :

if (vAmountType)='Units' then

[sum({<[Main Division Code Name]=>}sales_budget_units)]

{ elseif (vAmountType)='Value' then

[sum({<[Main Division Code Name]=>}sales_budget_units_value)]}

[ else

[0]]

end if

tresB — Wed, 11 Jun 2014 08:29:06 GMT

=if (vAmountType='Units' ,

sum({<[Main Division Code Name]=>}sales_budget_units) ,

if (vAmountType='Value' ,

sum({<[Main Division Code Name]=>}sales_budget_units_value) ,0))

Note, your variable vAmountType might have to be expanded with '$' sign, like if($(vAmountType) ='Units'