topic Re: need help in QlikView

need help

prma7799 — Tue, 09 Jun 2015 10:58:52 GMT

Hi all,

Am using one formula into text object and output is coming 0.0092228146015614 and -11.881221060977

So I want output like 0.9% and -11.9%

Can you please tell me how to achieve it.

Thanks

Re: need help

sushil353 — Tue, 09 Jun 2015 11:00:54 GMT

Hi,

Use NUM function as Num(Sales,'#,##0.00%')

HTH

sushil

Re: need help

PrashantSangle — Tue, 09 Jun 2015 11:02:16 GMT

Hi,

Try like

If(expression>0,expression*100,expression)& ' %'

Regards,

Re: need help

Anonymous — Tue, 09 Jun 2015 11:02:24 GMT

you can format using num function

num(your expression,'#0.0')

Re: need help

jonathandienst — Tue, 09 Jun 2015 11:05:22 GMT

Num(Sales,'0.0%')

Re: need help

Anonymous — Tue, 09 Jun 2015 11:10:50 GMT

For first expression you need to use if condition along with Num (),

=Num(if(num(0.0092228146015614,'#.##')<.1,num(0.0092228146015614,'#.##')*100,0.0092228146015614),'##.#')

for second you can directly use Num()

= Num(-11.881221060977,'#.#')

Thanks

BKC

Re: need help

Peter_Cammaert — Tue, 09 Jun 2015 11:10:58 GMT

Your request is quite difficult to accomplish. When using the num function with a format string that contains a percentage mark you will get an implicit multiplication by 100. For example:

0 -> 0%

0.5 -> 50%

1 -> 100%

num(0.009, '0.0%') will produce 0.9% as required. But num(-11.88, '0.0%') will produce... er -1188% and not -11.9%.

Isn't that what you want?

Peter

Re: need help

PrashantSangle — Tue, 09 Jun 2015 11:11:27 GMT

For rounding you can try

Num(If(expression>0,expression*100,expression),'#,#0.0')& ' %'

regards

Re: need help

Anonymous — Tue, 09 Jun 2015 11:11:33 GMT

replace hard coded values with expression