Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satish25
New 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
chinnuchinni
Contributor 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

4 Replies
chinnuchinni
Contributor III

Re: Arranging as per values

Try this :

test.PNG

satish25
New 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.

chinnuchinni
Contributor 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

satish25
New Contributor III

Re: Arranging as per values

Thanks a lot..!!

Community Browser