Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Chanty4u
Esteemed Contributor III

num format

hi,

i hve exp   in text object

ExP; num((count(Def_ID)),'#.#00'))*100

my result is 107994.44444444

Expexted output:  10.79%

how can i achieve in text object?

thanks in advance''

Suresh

1 Solution

Accepted Solutions

Re: num format

Try this as well

​=num((count(Def_ID)),'#.#00')*100&'%'

18 Replies

Re: num format

May be you need to divide by 100 instead of multiply by 100

Num((Count(Def_ID)/100, '##.00%')

roger_stone
Contributor III

Re: num format

Try num((count(Def_ID)),'#.#00'))/100

Chanty4u
Esteemed Contributor III

Re: num format

no sunny...its also givng same

Re: num format

Are you saying that *100 is giving you the same number as /100? or is the formatting is still the same?

Chanty4u
Esteemed Contributor III

Re: num format

No luck.....roger

Re: num format

Try this as well

​=num((count(Def_ID)),'#.#00')*100&'%'

Chanty4u
Esteemed Contributor III

Re: num format

the actual formulae....the above mentioned exp is denomenator  that shud be *100

Re: num format

This seems to be working:

=Num((1079.9444444444/10000), '##.00%')

Capture.PNG

So may be try dividing by 10000 instead of 100

Num((Count(Def_ID)/10000, '##.00%')

balrajahlawat
Esteemed Contributor

Re: num format

share your complete formula buddy..then only we can help you..