topic Re: Number Formating in QlikView

Number Formating

suryaa30 — Thu, 10 Aug 2017 10:53:01 GMT

Hi I am using below expression using Num fucntion. For large values the values are shown below. How do i resolve this?

=Num(Expression,'$###,###')

rahulpawarb — Thu, 10 Aug 2017 11:11:10 GMT

Use below given Number format:

=Num(Expression, '$###,##0')

Regards!

Rahul Pawar

suryaa30 — Thu, 10 Aug 2017 11:16:41 GMT

Thanks Rahul, what is the significance of the change and the break down of num function?

rahulpawarb — Fri, 11 Aug 2017 05:29:42 GMT

Hello Surya,

0 : Digit that has to be shown (can be used for padding 0's)

# : Digit is showed only if it's necessary

e.g.

Num(123, '0000') will show 0123

Num(123, '####') will show 123

Regards!

Rahul Pawar