topic Crosstab in QlikView https://community.qlik.com/t5/QlikView/Crosstab/m-p/283406#M105321 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Just change&nbsp; &lt;PURPOSE_R&gt;&nbsp; by &lt;RELATION_R&gt;&nbsp; </P><P></P><P>JJ</P></BODY></HTML> Tue, 06 Dec 2011 20:15:55 GMT 2011-12-06T20:15:55Z Crosstab https://community.qlik.com/t5/QlikView/Crosstab/m-p/283405#M105320 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">Does anyone know</SPAN> <SPAN class="hps">how to count</SPAN> <SPAN class="hps">100%</SPAN> <SPAN class="hps">of the columns</SPAN><SPAN>.</SPAN><BR /> <SPAN class="hps">I use</SPAN> <SPAN class="hps">2 dimensions (Purpose and Relation) and</SPAN> <SPAN class="hps">this is my</SPAN> <SPAN class="hps">expression</SPAN> </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P>Count({$&lt;QYYYY={'$(=QuarterName(max(QYYYY)))'}&gt;}RELATION_R)/</P><P>Count({&lt;QYYYY={'$(=QuarterName(max(QYYYY)))'}&gt;}TOTAL &lt;PURPOSE_R&gt;&nbsp; RELATION_R) </P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">that gives</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">100%</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">line.</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Please see my attached the file.<BR /></SPAN></SPAN></P><P><IMG /></P><P></P><P>Thanks,</P></BODY></HTML> Tue, 06 Dec 2011 20:01:29 GMT https://community.qlik.com/t5/QlikView/Crosstab/m-p/283405#M105320 Anonymous 2011-12-06T20:01:29Z Crosstab https://community.qlik.com/t5/QlikView/Crosstab/m-p/283406#M105321 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Just change&nbsp; &lt;PURPOSE_R&gt;&nbsp; by &lt;RELATION_R&gt;&nbsp; </P><P></P><P>JJ</P></BODY></HTML> Tue, 06 Dec 2011 20:15:55 GMT https://community.qlik.com/t5/QlikView/Crosstab/m-p/283406#M105321 2011-12-06T20:15:55Z Crosstab https://community.qlik.com/t5/QlikView/Crosstab/m-p/283407#M105322 <HTML><HEAD></HEAD><BODY><P>I got </P><P>Count({$&lt;QYYYY={'$(=QuarterName(max(QYYYY)))'}&gt;}PURPOSE_R)/</P><P>Count({&lt;QYYYY={'$(=QuarterName(max(QYYYY)))'}&gt;}TOTAL &lt;RELATION_R&gt;&nbsp; PURPOSE_R) </P></BODY></HTML> Tue, 06 Dec 2011 20:16:58 GMT https://community.qlik.com/t5/QlikView/Crosstab/m-p/283407#M105322 Anonymous 2011-12-06T20:16:58Z Crosstab https://community.qlik.com/t5/QlikView/Crosstab/m-p/283408#M105323 <HTML><HEAD></HEAD><BODY><P>Thank you Jean-Jacques.</P><P>I found out it too.</P></BODY></HTML> Tue, 06 Dec 2011 20:19:15 GMT https://community.qlik.com/t5/QlikView/Crosstab/m-p/283408#M105323 Anonymous 2011-12-06T20:19:15Z