Issue while loading excel

[vipingarg23]

Hi Team,

I have an excel file where I have data as an attached excel file. When I am loading that excel, data is coming wrong. Means for India Country, I have three state (x,y,z) but In Qlikview, it is shwing only one(X). Please find the attached qvw file.

I don't want to change excel file. How I can get all three state in qlikview listbox?

[olivierrobin]

hello

you see only one value because each value is separated by chr(10)

if you use

LOAD County,

     replace(State,chr(10),'/') as State

you will see the values

[vipingarg23]

Thanks Olivier for your quick reply.

If I want to sell all value in new line like below instead of X/Y/Z:

X

Y

Z

How we can achieve this?

[olivierrobin · Accepted solution]

maybe something like :

LOAD County,

     subfield(State,chr(10)) as State

FROM

[vipingarg23]

Great !!

Thanks Olivier for your quick answer. It is working fine.

[Anonymous]

Hi,