Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matancha
Creator
Creator

Number Format

Hello All.

I have field with 2 numbers: 1.5625 , 3

I want to display them (Straight Table atc...) like: 1.56, 3 (And NOT 3.00, I try - '#,##0.##' )

How can I do that? Which format I need?

Thks for your help -

Matan

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Oops - missed a parenthesis:

Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))

Jason

View solution in original post

4 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Hmmm,

Try Num(Value,If(Value=Floor(Value),'#,##0','#,##0.00'))

Hope this helps,

Jason

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Oops - missed a parenthesis:

Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))

Jason

matancha
Creator
Creator
Author

Thnks Jason,

It's Work.

But Maybe there a way only with format pattern (without If)?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Not that I can think of I'm afraid.