topic Need help with dividing column with column total in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-dividing-column-with-column-total/m-p/381624#M1168926 <HTML><HEAD></HEAD><BODY><P>I have a column that is totals up how many items in a classification </P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ItemNumber</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">That works great, but I want to divide the row total for the item classification with the column total for the items numbers.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">For example </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Item Class&nbsp;&nbsp;&nbsp;&nbsp; Number of items Percentage of Items</SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</SPAN></P><P><SPAN style="font-size: 8pt;">Pink&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%</SPAN></P><P><SPAN style="font-size: 8pt;">Blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40%</SPAN></P><P><SPAN style="font-size: 8pt;">Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40%</SPAN></P><P></P><P>I need the forumla for the percentage of items</P></BODY></HTML> Tue, 28 Aug 2012 15:57:48 GMT 2012-08-28T15:57:48Z Need help with dividing column with column total https://community.qlik.com/t5/QlikView/Need-help-with-dividing-column-with-column-total/m-p/381624#M1168926 <HTML><HEAD></HEAD><BODY><P>I have a column that is totals up how many items in a classification </P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">NUM</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ItemNumber</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">That works great, but I want to divide the row total for the item classification with the column total for the items numbers.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">For example </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Item Class&nbsp;&nbsp;&nbsp;&nbsp; Number of items Percentage of Items</SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</SPAN></P><P><SPAN style="font-size: 8pt;">Pink&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%</SPAN></P><P><SPAN style="font-size: 8pt;">Blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40%</SPAN></P><P><SPAN style="font-size: 8pt;">Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40%</SPAN></P><P></P><P>I need the forumla for the percentage of items</P></BODY></HTML> Tue, 28 Aug 2012 15:57:48 GMT https://community.qlik.com/t5/QlikView/Need-help-with-dividing-column-with-column-total/m-p/381624#M1168926 2012-08-28T15:57:48Z Re: Need help with dividing column with column total https://community.qlik.com/t5/QlikView/Need-help-with-dividing-column-with-column-total/m-p/381625#M1168927 <HTML><HEAD></HEAD><BODY><P>percentage</P><P>count(Number of items)/cOUNT(TOTAL Number of items )</P></BODY></HTML> Tue, 28 Aug 2012 16:00:31 GMT https://community.qlik.com/t5/QlikView/Need-help-with-dividing-column-with-column-total/m-p/381625#M1168927 2012-08-28T16:00:31Z