Discussion board where members can get started with Qlik Sense.
Hello Qlik Experts,
I require an output as displayed above. I want to display the data in different columns as shown.
I have used IF clause but it only displays only one section at a time and the other 2 sections appear blank.
I want all the sections to appear in a single row without any blank values.
Thanks in Advance.
FROM (ooxml, embedded labels, table is Sheet2);
load Type as type1,
Number as Number1,
City as City1 Resident Xyz where Type = 'A' ;
load Type as type2,
Number as Number2,
City as City2 Resident Xyz where Type = 'B' ;
load Type as type3,
Number as Number3,
City as City3 Resident Xyz where Type = 'C' ;
EXIT SCRIPT ;
View solution in original post
Try this :
Hey thanks a lot for your reply.
This works perfectly in the front end.
However I have a lot of fields, so is it possible to write this in the Script (Back end).
If Yes, could you please tell me the code.
Thanks a lot..!!