Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

Issue while loading excel

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?

1 Solution

Accepted Solutions
olivierrobin
Specialist III
Specialist III

maybe something like :

LOAD County,

     subfield(State,chr(10)) as State

FROM

View solution in original post

5 Replies
olivierrobin
Specialist III
Specialist III

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
Creator
Creator
Author

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
Specialist III
Specialist III

maybe something like :

LOAD County,

     subfield(State,chr(10)) as State

FROM

vipingarg23
Creator
Creator
Author

Great !!

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

Anonymous
Not applicable

Hi,

Capture2.PNG

Capture.PNG