Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

setting numerical format

Good day, you can put in the same column of a table different types of number formats.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Are you talking about a column in a table chart?

You can have your expression return differently formatted values, setting the number format on number tab to expression default:

=If(Dimension = 'A', Num(Sum(Value),'#,###.00','.',','), Money( Sum(Value) ) )

View solution in original post

3 Replies
Anonymous
Not applicable
Author

What is your use case for wishing to do this ?

swuehl
MVP
MVP

Are you talking about a column in a table chart?

You can have your expression return differently formatted values, setting the number format on number tab to expression default:

=If(Dimension = 'A', Num(Sum(Value),'#,###.00','.',','), Money( Sum(Value) ) )

Not applicable
Author

Like this table

2015-12-04_14-09-17.png