Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
maybe something like :
LOAD County,
subfield(State,chr(10)) as State
FROM
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
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?
maybe something like :
LOAD County,
subfield(State,chr(10)) as State
FROM
Great !!
Thanks Olivier for your quick answer. It is working fine.
Hi,