topic Re: Issue while loading excel in QlikView

Issue while loading excel

vipingarg23 — Mon, 03 Sep 2018 11:42:24 GMT

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?

Re: Issue while loading excel

olivierrobin — Mon, 03 Sep 2018 11:55:33 GMT

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

Re: Issue while loading excel

vipingarg23 — Mon, 03 Sep 2018 12:09:59 GMT

Thanks Olivier for your quick reply.

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

How we can achieve this?

Re: Issue while loading excel

olivierrobin — Mon, 03 Sep 2018 12:18:48 GMT

maybe something like :

LOAD County,

subfield(State,chr(10)) as State

FROM

Re: Issue while loading excel

vipingarg23 — Mon, 03 Sep 2018 12:26:53 GMT

Great !!

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

Re: Issue while loading excel

Anonymous — Mon, 03 Sep 2018 12:44:19 GMT

Hi,