topic Re: =Num() query in QlikView

=Num() query

knightwriter — Wed, 26 Aug 2015 11:00:04 GMT

Hi All,

I am trying to divide two expressions by one another and the end result to give me xx.0. I have used the below and the answer I get is xx.xxxxxxxxxxxxx. What am I doing wrong?

=num(expression1), '##.0') / num(expression2). '##.0')

Re: =Num() query

prajapatiamar38 — Wed, 26 Aug 2015 11:06:44 GMT

try this:

=num((expression1), '##.0') / num((expression2), '##.0')

Re: =Num() query

knightwriter — Wed, 26 Aug 2015 11:13:20 GMT

thanks for the reply but this does not solve my query.

Re: =Num() query

mohammadkhatimi — Wed, 26 Aug 2015 11:17:40 GMT

Hie..

Goto chart properties-->>Numbers Tab-->>Select Integer-->>in that '##.0'

Hope this will helps you..!!

Regards,

Mohammad

Re: =Num() query

knightwriter — Wed, 26 Aug 2015 11:20:16 GMT

Unfortunately I am using text box properties and your suggestion is not available.

Re: =Num() query

mohammadkhatimi — Wed, 26 Aug 2015 11:22:31 GMT

Try this

=num(num((expression1), '##.0') / num((expression2), '##.0'),'##.0'))

=num(expression1 /expression2, '##.0')

Hope this will helps you..!!

Regards,

Mohammad

Re: =Num() query

MarcoWedel — Wed, 26 Aug 2015 11:23:46 GMT

=num(expression1 /expression2, '##.0')

Re: =Num() query

prajapatiamar38 — Wed, 26 Aug 2015 11:23:55 GMT

can you post your expression?

Re: =Num() query

sasiparupudi1 — Wed, 26 Aug 2015 11:27:12 GMT

=num(expression1/expression2), '##.0')