while loading +1, +2 values from excel into Qlikview getting result as 01 or 1 but wants exactly +1 , +2

[nagarjuna005]

Hi All ,

i have a column REFVAL and values are +1,+2  in excel so when i am loading into Qlikview +1 ,+2 values are not coming into Qlikview .

i want to see exactly +1,+2 from excel into qlikview.

can anyone help on this thanks!!

[Or]

I can't quite understand what it is you're doing / having issues with.

If the value in Excel is the text string '+1', Qlik should be able to read it without issues as a text string.

LOAD
Column
FROM [lib://AttachedFiles/Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

[anat]

u can try using chr(field)

[NitinK7]

try to keep it as text using the text function

Load 

text (your column name) as column  name

from ..