Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
];

MVP & Luminary
MVP & Luminary

You can use calculated dimensions like:

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

-Rob