topic Re: Crosstable? in QlikView https://community.qlik.com/t5/QlikView/Crosstable/m-p/488720#M182620 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>CrossTable(Social,Value)</P><P>LOAD * Inline</P><P>[</P><P>ID,Facebook,LinkedIn</P><P>123,true,false</P><P>456,false,false</P><P>];</P></BODY></HTML> Tue, 13 Aug 2013 10:17:32 GMT MayilVahanan 2013-08-13T10:17:32Z Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/488719#M182619 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Facebook</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LinkedIn</STRONG></SPAN></TH></TR><TR><TD>123</TD><TD>true</TD><TD>false</TD></TR><TR><TD>456</TD><TD>false</TD><TD>false</TD></TR></TBODY></TABLE><P></P><P>And i would like to transform it into something like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Social</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>123</TD><TD>Facebook</TD><TD>true</TD></TR><TR><TD>123</TD><TD>LinkedIn</TD><TD>false</TD></TR><TR><TD>456</TD><TD>Facebook</TD><TD>false</TD></TR><TR><TD>456</TD><TD>LinkedIn</TD><TD>false</TD></TR></TBODY></TABLE><P></P><P>How can this be done ?</P><P></P><P>Thanks a lot!</P><P>K</P></BODY></HTML> Tue, 13 Aug 2013 10:08:20 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/488719#M182619 2013-08-13T10:08:20Z Re: Crosstable? https://community.qlik.com/t5/QlikView/Crosstable/m-p/488720#M182620 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>CrossTable(Social,Value)</P><P>LOAD * Inline</P><P>[</P><P>ID,Facebook,LinkedIn</P><P>123,true,false</P><P>456,false,false</P><P>];</P></BODY></HTML> Tue, 13 Aug 2013 10:17:32 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/488720#M182620 MayilVahanan 2013-08-13T10:17:32Z