Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to ensure QV reads the same field format?

I have a field from our company data warehouse called "Site."  In the field are characters like "1001" and "2001" but I am not sure if they are text or numeric.  In one of the tables I am loading in the script, I have to manually add a field called "Site" and need to ensure it = 1001.  When I bring the data into the app, it seems like 1001 in my homemade field does not equal 1001 from the field in the data warehouse.  I'm wondering if these are both different fields, like one is text and one numeric.  How do I ensure it reads them both as numeric or both as text?  This is probably and easy fix, I just don't know the correct functions.  Thanks! 

2 Replies

Re: How to ensure QV reads the same field format?

QlikView at first glance will read as Numeric Format to both your field.

If you want to make sure that you want QlikView to read 1001 as text, use below in your script.

Text(YourFieldName) as YourFieldName

Employee
Employee

Re: How to ensure QV reads the same field format?

Do you want them numbers or text?

1) Numbers:  maybe you have to trim your values while loadind

LOAD

    trim(yourfield) as yourfield

2) Text

load

  text(yourfield) as yourfield

Community Browser