topic Pivot table - Getting ratio based on partial total in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488945#M480431 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>For each product I'd like to calculate the ratio of each validity date in terms of quantity. Please see attached file for incorrect approach. what I am looking for is for Product A it's 100% as it only has one validity date, Product B, should be 40%, 20%, 20% and 20% so that they add up to 100%.</P><P></P><P>I used the samiliar formula for Sum(total &lt;&gt;...) it worked but now I have to use Count. does the syntas differ for Count?? Thanks!</P></BODY></HTML> Mon, 25 Nov 2013 23:04:12 GMT 2013-11-25T23:04:12Z Pivot table - Getting ratio based on partial total https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488945#M480431 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>For each product I'd like to calculate the ratio of each validity date in terms of quantity. Please see attached file for incorrect approach. what I am looking for is for Product A it's 100% as it only has one validity date, Product B, should be 40%, 20%, 20% and 20% so that they add up to 100%.</P><P></P><P>I used the samiliar formula for Sum(total &lt;&gt;...) it worked but now I have to use Count. does the syntas differ for Count?? Thanks!</P></BODY></HTML> Mon, 25 Nov 2013 23:04:12 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488945#M480431 2013-11-25T23:04:12Z Re: Pivot table - Getting ratio based on partial total https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488946#M480432 <HTML><HEAD></HEAD><BODY><P>See the attached.</P></BODY></HTML> Tue, 26 Nov 2013 14:04:50 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488946#M480432 Nicole-Smith 2013-11-26T14:04:50Z Re: Pivot table - Getting ratio based on partial total https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488947#M480433 <HTML><HEAD></HEAD><BODY><P><BR />Nicole- thanks a lot!</P></BODY></HTML> Tue, 26 Nov 2013 14:24:52 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488947#M480433 2013-11-26T14:24:52Z Re: Pivot table - Getting ratio based on partial total https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488948#M480434 <HTML><HEAD></HEAD><BODY><P>I'm glad it worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 26 Nov 2013 14:25:40 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Getting-ratio-based-on-partial-total/m-p/488948#M480434 Nicole-Smith 2013-11-26T14:25:40Z