topic Re: whats wrong with this expression??!! in QlikView

whats wrong with this expression??!!

Wed, 16 Jan 2013 17:04:39 GMT

I have the following expression

=if(MonthName = 'Dec 2012',num(Avg([Satisfaction Score]),'##')-88,num(Avg([Satisfaction Score]),'##')-89) & '%'

but am getting the result as 9.5 which should be rounded to 10

swuehl — Wed, 16 Jan 2013 17:08:23 GMT

I would suggest using a format code like '0' instead of '##'. Or use round() function.

erichshiino — Wed, 16 Jan 2013 17:20:32 GMT

Instead of formating when if is true and when it is false, you can just round the if:

=round(if(MonthName = 'Dec 2012',(Avg([Satisfaction Score])')-88,(Avg([Satisfaction Score]))-89)) & '%'

I guess it failed because you used num, but you included another oepration (- 88 or -89) and the format was lost

Hope it helps,

Erich