Number format in Qliksense

[VVJ]

Hi All,

I've prepared a table and one of my column contains value as 100.00 

I want to display the same as 100,0 instead of 100.00.

Suggestions to change it at table level or data loading is much appreciated. Thanks.

[R_Kaymakchiev · Accepted solution]

Hi, 

you can simply change the appearance of the Measure number formating.

There are predefined and custom formats.

This custom format ->     #.##0,0    will allow you see the number like 100,0 

Example:

[VVJ · Accepted solution]

Hi,

Thanks for your help. It worked if added the column as a Measure.

But as I did not add the column as a measure, I used following expression which fixed the issue

=num(height,'###,0',',','.')