Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SamuelHaag
Contributor III
Contributor III

Format of Numbers in "View Data"

Hi,

how can I change the format of the numbers in the table of "View Data" ?

 

In the normal view of my chart it's formated like this:

20-12-_2019_11-32-46.png

But when I click on "View Data" I the number is shown like this without any seperations:

20-12-_2019_11-36-12.png

 

 
 
 

Thank you!

Labels (5)
6 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Samuel,

Could you give a bit more context for the image? I can image you can't show sensitive data, but I can't make anything out of this image.

The solution is probably something like format.

Jordy

Climber

Work smarter, not harder
SamuelHaag
Contributor III
Contributor III
Author

Hi,

thank you for your answer. I made a .gif to describe it a little bit better.

I want to get the numbers (in "view data" of a diagram) with a seperator 

for example 87918882,69 should be displayed as 87.918.882,69 or 87,91 Mio. so it's easier to read

Is this possible?

09-01-_2020_15-31-09.gif

 

I hope this helps

Thank you!

ken4runner
Creator
Creator

facing this same issue - has anyone found a solution for this?

Uttamjit
Partner - Contributor
Partner - Contributor

Hi, I am facing the same problem. Has anyone found the solution to it?

Almen
Creator II
Creator II

You have to define the number format of your measure. If you leave it at automatic, the data will be unformatted.

Uttamjit
Partner - Contributor
Partner - Contributor

I still want to show the number in numerical abbreviations when showing the chart. But when I view data by right clicking the chart, need to apply the formatting like decimal places etc.