topic Re: Crosstable with two columns. in App Development https://community.qlik.com/t5/App-Development/Crosstable-with-two-columns/m-p/60677#M3995 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>CrossTable (WeekNum, Figures<SPAN style="color: #ff0000;">, 2</SPAN>)</STRONG></P><P><STRONG>LOAD Year,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; KPI,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK01,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK02,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK03,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK04,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEL05</STRONG></P><P><STRONG>FROM ...;</STRONG></P></BODY></HTML> Wed, 21 Feb 2018 17:49:51 GMT sunny_talwar 2018-02-21T17:49:51Z Crosstable with two columns. https://community.qlik.com/t5/App-Development/Crosstable-with-two-columns/m-p/60676#M3994 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>We have data like this, I was wondering how would be the best way to get this into Qlik.</P><P>I know i need to crosstable but i need 4 Filters.</P><P></P><P>I need</P><UL><LI>Year</LI><LI>KPI</LI><LI>WeekNum</LI><LI>Figures (This being the data)</LI></UL><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193998_Capture.PNG" style="max-width: 620px; height: auto;" /></P><P></P><P>Thank!</P></BODY></HTML> Wed, 21 Feb 2018 09:02:20 GMT https://community.qlik.com/t5/App-Development/Crosstable-with-two-columns/m-p/60676#M3994 Anonymous 2018-02-21T09:02:20Z Re: Crosstable with two columns. https://community.qlik.com/t5/App-Development/Crosstable-with-two-columns/m-p/60677#M3995 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>CrossTable (WeekNum, Figures<SPAN style="color: #ff0000;">, 2</SPAN>)</STRONG></P><P><STRONG>LOAD Year,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; KPI,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK01,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK02,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK03,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEK04,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WEEL05</STRONG></P><P><STRONG>FROM ...;</STRONG></P></BODY></HTML> Wed, 21 Feb 2018 17:49:51 GMT https://community.qlik.com/t5/App-Development/Crosstable-with-two-columns/m-p/60677#M3995 sunny_talwar 2018-02-21T17:49:51Z