topic Re: Percentage column in QlikView https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157293#M901430 <HTML><HEAD></HEAD><BODY><P>Works! Thanks so much!</P></BODY></HTML> Thu, 14 Jul 2016 13:19:52 GMT 2016-07-14T13:19:52Z Percentage column https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157290#M901427 <HTML><HEAD></HEAD><BODY><P>Hello, please i need help with this</P><P>I have this table:&nbsp; </P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl63" height="17" width="98">Status</TD><TD class="xl64" width="98">Pax</TD><TD class="xl64" style="border-left: none;" width="98">Pax %</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Booked</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3.329</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Optioned</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12.190</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Cancelled</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">37.178</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Revised</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4.535</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">Quoted</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">48.635</TD><TD class="xl66" style="border-top: none; border-left: none;"><P>1</P></TD></TR></TBODY></TABLE><P></P><P>I am trying to split the status by the quoted ammount being this the 100%. I attached a picture of the qlikview Formula</P><P></P><P>Thanks so much</P><P></P><P>Belén</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157290#M901427 2020-11-25T16:16:04Z Re: Percentage column https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157291#M901428 <HTML><HEAD></HEAD><BODY><P>Try num(sum(Pax)/sum({&lt;Status={'Quoted'}&gt;}TOTAL Pax),'0.0%')</P></BODY></HTML> Thu, 14 Jul 2016 11:46:55 GMT https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157291#M901428 Gysbert_Wassenaar 2016-07-14T11:46:55Z Re: Percentage column https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157292#M901429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be if u want like this&nbsp;&nbsp; Go to Expression tab--&gt;Select Expression--&gt; Chick the (click)&nbsp; Relative option </P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131270_Untitled.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Thu, 14 Jul 2016 11:56:56 GMT https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157292#M901429 qlikview979 2016-07-14T11:56:56Z Re: Percentage column https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157293#M901430 <HTML><HEAD></HEAD><BODY><P>Works! Thanks so much!</P></BODY></HTML> Thu, 14 Jul 2016 13:19:52 GMT https://community.qlik.com/t5/QlikView/Percentage-column/m-p/1157293#M901430 2016-07-14T13:19:52Z