Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Arranging as per values

Hello Qlik Experts,

Capture.JPG

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.

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Arranging as per values

Xyz:

LOAD Type,

Number,

City

FROM (ooxml, embedded labels, table is Sheet2);



A1:

load Type as type1,

Number as Number1,

City as City1 Resident Xyz where Type = 'A' ;

A1:

load Type as type2,

Number as Number2,

City as City2 Resident Xyz where Type = 'B' ;

A1:

load Type as type3,

Number as Number3,

City as City3 Resident Xyz where Type = 'C' ;


EXIT SCRIPT ;test2.PNG

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Re: Arranging as per values

Try this :

test.PNG

Highlighted
Contributor III
Contributor III

Re: Arranging as per values

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.

Highlighted
Creator III
Creator III

Re: Arranging as per values

Xyz:

LOAD Type,

Number,

City

FROM (ooxml, embedded labels, table is Sheet2);



A1:

load Type as type1,

Number as Number1,

City as City1 Resident Xyz where Type = 'A' ;

A1:

load Type as type2,

Number as Number2,

City as City2 Resident Xyz where Type = 'B' ;

A1:

load Type as type3,

Number as Number3,

City as City3 Resident Xyz where Type = 'C' ;


EXIT SCRIPT ;test2.PNG

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Arranging as per values

Thanks a lot..!!