Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
VVJ
Contributor II
Contributor II

Number format in Qliksense

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.

2 Solutions

Accepted Solutions
R_Kaymakchiev
Luminary
Luminary

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:

Number Formating.png

 

View solution in original post

VVJ
Contributor II
Contributor II

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',',','.')

 

 

View solution in original post

2 Replies
R_Kaymakchiev
Luminary
Luminary

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:

Number Formating.png

 

View solution in original post

VVJ
Contributor II
Contributor II

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',',','.')

 

 

View solution in original post