topic Re: Percentage count ? in QlikView https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158848#M630030 <HTML><HEAD></HEAD><BODY><P>Can you please post application</P><P></P><P>R</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">count({&lt;TripNum ={"=count(distinct Type&gt;0"}&gt;} distinct TripNum)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">/Count({&lt;Type=&gt;} <STRONG>TOTAL</STRONG> TripNum)</P></BODY></HTML> Wed, 07 Sep 2016 15:29:38 GMT Anil_Babu_Samineni 2016-09-07T15:29:38Z Percentage count ? https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158847#M630029 <HTML><HEAD></HEAD><BODY><P><STRONG>TableA</STRONG>:</P><P><STRONG>TripNum&nbsp;&nbsp; Traveler&nbsp; Type</STRONG></P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Indirect</P><P>198&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct</P><P>190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Online</P><P>908&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Indirect</P><P></P><P><STRONG>TableB</STRONG>:</P><P><STRONG>TripNum&nbsp;&nbsp; Traveler&nbsp; Type</STRONG></P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rental</P><P>153&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rental</P><P>190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>164&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rental</P><P></P><P>Now I used the following expression to the TripNum % :</P><P>count({&lt;TripNum ={"=count(distinct Type&gt;0"}&gt;} distinct&nbsp; TripNum)</P><P>/Count({&lt;Type=&gt;} distinct (TripNum))</P><P></P><P>I am getting the TripNum %, but the problem here is when I select Rental in Type filter, </P><P>it is calculating for all tripnum count, instead I want it to consider only count from Table2. </P><P>Without any selections applied, it is working fine.</P><P><SPAN style="color: #ffffff; font-size: 14px; background-color: #333333; font-family: 'Helvetica Neue', Roboto, 'Segoe UI', Calibri, sans-serif;">how can get % for only rental : actual o/p: 3/9= 33.33</SPAN></P><P><SPAN style="color: #ffffff; font-size: 14px; background-color: #333333; font-family: 'Helvetica Neue', Roboto, 'Segoe UI', Calibri, sans-serif;">expected %= 3/4=75%,</SPAN></P></BODY></HTML> Wed, 07 Sep 2016 11:21:46 GMT https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158847#M630029 prashanth1712 2016-09-07T11:21:46Z Re: Percentage count ? https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158848#M630030 <HTML><HEAD></HEAD><BODY><P>Can you please post application</P><P></P><P>R</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">count({&lt;TripNum ={"=count(distinct Type&gt;0"}&gt;} distinct TripNum)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">/Count({&lt;Type=&gt;} <STRONG>TOTAL</STRONG> TripNum)</P></BODY></HTML> Wed, 07 Sep 2016 15:29:38 GMT https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158848#M630030 Anil_Babu_Samineni 2016-09-07T15:29:38Z Re: Percentage count ? https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158849#M630031 <HTML><HEAD></HEAD><BODY><P>Are these two tables getting concatenated together in your data model? Can you elaborate the reason for seeing the information from only table 2 when Rental is selected?</P></BODY></HTML> Wed, 07 Sep 2016 19:22:22 GMT https://community.qlik.com/t5/QlikView/Percentage-count/m-p/1158849#M630031 sunny_talwar 2016-09-07T19:22:22Z