Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
bill_markham
Champion III
Champion III

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) ) )

View solution in original post

Not applicable
Author

Like this table

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