Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (3)
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.