Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Qlik Table - View

Hi everyone,

Can some one help me with the table format that I am looking for>?

Here below are the details

Below is the Table I have

LOAD * INLINE [
F1, F2, F3, F4, F5
abc, 123, 12-Oct, 1, sfdi
abc, 233, 13-Oct, 2, fd
abc, 453, 14-Oct, 2, fd
abc, 532, 15-Oct, 1, sdcf
sfsfk, 4332, 12-Oct, 1, as
dekfje, 32437, 13-Oct, 2, fd
dekfje, 432, 14-Oct, 1, fd
sfsfk, 423, 15-Oct, 1, aG
bbn, 53432, 14-Oct, 1, sdffg
bbn, 98909, 13-Oct, 1, sdffg
];

The resultant table should look like the one below. Any help on this would be highly appreciated.

Untitled.png

 

 

3 Replies
Highlighted
Luminary
Luminary

I answered this on your other post as well. Please try to keep from making duplicate posts.

LOAD 
    F1                              as FieldOne,
    Pick(F4, F2 & F3)               as FieldTwo,
    Pick(F1, F5)                    as FieldThree,
    Pick(F4, Null(), F2 & F3)       as FieldFour,
    Pick(F4, Null(), F5)            as FieldFive
INLINE [
F1, F2, F3, F4, F5
abc, 123, 12-Oct, 1, sfdi
abc, 233, 13-Oct, 2, fd
abc, 453, 14-Oct, 2, fd
abc, 532, 15-Oct, 1, sdcf
sfsfk, 4332, 12-Oct, 1, as
dekfje, 32437, 13-Oct, 2, fd
dekfje, 432, 14-Oct, 1, fd
sfsfk, 423, 15-Oct, 1, aG
bbn, 53432, 14-Oct, 1, sdffg
bbn, 98909, 13-Oct, 1, sdffg
];

 

Blog: WhereClause   Twitter: @treysmithdev
Contributor III
Contributor III

LOAD F1,
if(F4=1, F2 & F3,'') as "F2&F3 (When F4 is 1)",
if(F4=1, F5,'') as "F5 (When F4 is 1)",
if(F4=2, F2 & F3,'') as "F2&F3 (When F4 is 2)",
if(F4=2, F5,'') as "F5 (When F4 is 2)";
LOAD * INLINE [
F1, F2, F3, F4, F5
abc, 123, 12-Oct, 1, sfdi
abc, 233, 13-Oct, 2, fd
abc, 453, 14-Oct, 2, fd
abc, 532, 15-Oct, 1, sdcf
sfsfk, 4332, 12-Oct, 1, as
dekfje, 32437, 13-Oct, 2, fd
dekfje, 432, 14-Oct, 1, fd
sfsfk, 423, 15-Oct, 1, aG
bbn, 53432, 14-Oct, 1, sdffg
bbn, 98909, 13-Oct, 1, sdffg
];

Highlighted
MVP & Luminary
MVP & Luminary

You can use calculated dimensions like:

=aggr(only({<F4={1}>}F2 & ' ' & F3), F2)

-Rob