Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Crosstable?

Hi all,

i have a table like this:

IDFacebookLinkedIn
123truefalse
456falsefalse

And i would like to transform it into something like this:

IDSocialValue
123Facebooktrue
123LinkedInfalse
456Facebookfalse
456LinkedInfalse

How can this be done ?

Thanks a lot!

K

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

CrossTable(Social,Value)

LOAD * Inline

[

ID,Facebook,LinkedIn

123,true,false

456,false,false

];

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply
MayilVahanan

HI

Try like this

CrossTable(Social,Value)

LOAD * Inline

[

ID,Facebook,LinkedIn

123,true,false

456,false,false

];

Thanks & Regards,
Mayil Vahanan R

View solution in original post