Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Igor-Ribeiro-Nordica
Contributor
Contributor
‎2023-07-27 08:51 AM

Numeric value on Data Model, but Text in Sheet graphs

I have a problem where I am loading the data correctly as a Numeric value as shown in the Data Model tab, but when I will try to use the field in the Sheets tab it formats as Text.

Data Model tab:

IgorRibeiroNordica_0-1690462172190.png

Sheet tab:

IgorRibeiroNordica_1-1690462223031.png

 

Labels (2)
466 Views
0 Likes
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP
‎2023-07-27 10:56 AM

Its not the same view on the matter - all numbers are dual() and have a numeric value and a string-representation of this value which is usually identically but it mustn't be. Within the UI everything showed which isn't a link or image is displayed with their string-representation. You could calculate with it and format it like you want - it will work.

View solution in original post

451 Views
1 Reply
marcus_sommer
MVP
MVP
‎2023-07-27 10:56 AM

Its not the same view on the matter - all numbers are dual() and have a numeric value and a string-representation of this value which is usually identically but it mustn't be. Within the UI everything showed which isn't a link or image is displayed with their string-representation. You could calculate with it and format it like you want - it will work.

452 Views