Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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