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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pam1990
Contributor III
Contributor III

Why do numeric values load as text?

I created my first QVD with concatenation. Yay!!

I doubt that has anything to do with my issue, but I wanted to mention that.

I've searched and I cannot find a specific solution to why numeric values from tables come over as text. As a result, I can not do summations.

Assistance with this is appreciated.

Labels (2)
1 Solution

Accepted Solutions
pam1990
Contributor III
Contributor III
Author

I figured out the issue. I was using a dimension instead of a measure.

View solution in original post

2 Replies
Chanty4u
MVP
MVP

hi,

from where you are loading the data into Qlik?

first you need to check the data from source is text or numeric ?  its based on Datatype. 

 

if you want to convert  numeric to text in qlik. use below.

1.   num#(Field)  as newfield

2.  Evaluate(field) as Newfield

pam1990
Contributor III
Contributor III
Author

I figured out the issue. I was using a dimension instead of a measure.