topic if statement in text object properties in QlikView

if statement in text object properties

nazaninslp — Wed, 25 Nov 2020 16:16:04 GMT

Dears

I want to show usage amount in text object and it contains if statement too, but when I run below ode , it just show a plain dash(-) like below :

IF(PRICE='0',NUM(sum(USAGE_VOICE_H)/sum(VOICE),'#.0%'))

I read lots of samples about this issue and changed my query to below one, but now the amount is wrong, it should be 7.3%.

would you please help me?

=sum(IF(PRICE='0',num((USAGE_VOICE_H)/(VOICE)),'#.0%'))

sunny_talwar — Wed, 28 Feb 2018 17:39:15 GMT

Try this

Num(Sum({<PRICE = {'0'}>} USAGE_VOICE_H)/Sum({<PRICE = {'0'}>}VOICE), '#.0%')

nazaninslp — Fri, 02 Mar 2018 13:39:29 GMT

Thank you soooooooooo much

it is working fine now !