Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
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
Highlighted
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