Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

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

Highlighted
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