topic Re: while loading +1, +2 values from excel into Qlikview getting result as 01 or 1 but wants exactly +1 , +2 in App Development

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

nagarjuna005 — Tue, 15 Mar 2022 10:58:09 GMT

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 — Tue, 15 Mar 2022 11:02:45 GMT

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 — Tue, 15 Mar 2022 11:10:25 GMT

u can try using chr(field)

NitinK7 — Tue, 15 Mar 2022 11:22:51 GMT

try to keep it as text using the text function

Load

text (your column name) as column name

from ..