Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
suryaa30
Contributor II

Number Formating

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

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

doubt.JPG

Tags (1)
1 Solution

Accepted Solutions
rahulpawarb
Valued Contributor III

Re: Number Formating

Use below given Number format:

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

Regards!

Rahul Pawar

3 Replies
rahulpawarb
Valued Contributor III

Re: Number Formating

Use below given Number format:

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

Regards!

Rahul Pawar

suryaa30
Contributor II

Re: Number Formating

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

rahulpawarb
Valued Contributor III

Re: Number Formating

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