topic Re: calculation distinct in QlikView https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096457#M466276 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot_2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114317_Screenshot_2.png" style="height: 310px; width: 620px;" /></P></BODY></HTML> Thu, 11 Feb 2016 12:40:31 GMT 2016-02-11T12:40:31Z calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096451#M466270 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Hi </SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">How to count the number of <SPAN lang="en">ranches </SPAN>in which there document.2 ? </SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Thank you</SPAN></P></BODY></HTML> Thu, 11 Feb 2016 09:56:40 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096451#M466270 2016-02-11T09:56:40Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096452#M466271 <HTML><HEAD></HEAD><BODY><P>A Straight Table with :</P><UL><LI><SPAN style="font-size: 10pt; line-height: 1.5em;">Dimension&nbsp;&nbsp;&nbsp; </SPAN><EM style="font-size: 10pt; line-height: 1.5em;">docum</EM><EM style="font-size: 13.3333px; line-height: 20px;">ent</EM></LI><LI><SPAN style="font-size: 13.3333px; line-height: 1.5em;">Expression&nbsp; </SPAN><SPAN style="font-size: 13.3333px; line-height: 1.5em;"> </SPAN><EM style="font-size: 13.3333px; line-height: 1.5em;">= Count (&nbsp; distinct branch )</EM></LI></UL><P><EM style="font-size: 13.3333px; line-height: 1.5em;"><BR /></EM>Will give the count of ranches for each document.</P><P></P><P>You can select <EM>document2</EM> if that is the only one you wish to see.</P></BODY></HTML> Thu, 11 Feb 2016 12:19:24 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096452#M466271 Anonymous 2016-02-11T12:19:24Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096453#M466272 <HTML><HEAD></HEAD><BODY><P>Hi Marina,</P><P></P><P>see the additional table in the attached.</P><P></P><P>HTH</P><P></P><P>Andy</P></BODY></HTML> Thu, 11 Feb 2016 12:25:43 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096453#M466272 awhitfield 2016-02-11T12:25:43Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096454#M466273 <HTML><HEAD></HEAD><BODY><P>It is not exactly<IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114304_Screenshot_1.png" style="height: 249px; width: 620px;" /></P></BODY></HTML> Thu, 11 Feb 2016 12:33:14 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096454#M466273 2016-02-11T12:33:14Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096455#M466274 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this,</P><P></P><P><STRONG>Dimension:</STRONG></P><P></P><P>branch</P><P></P><P><STRONG>Expression:</STRONG></P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14551939300675720 jive_text_macro" jivemacro_uid="_14551939300675720"> <P>=Count(DISTINCT{&lt;document={'document2'}&gt;}document)</P> </PRE><P></P><P><IMG alt="Distinct-205167.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114316_Distinct-205167.PNG" style="height: auto; width: auto;" /></P><P></P><P>Hope this helps,</P><P>PFA,</P><P>Hirish</P></BODY></HTML> Thu, 11 Feb 2016 12:33:26 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096455#M466274 HirisH_V7 2016-02-11T12:33:26Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096456#M466275 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">I'm looking for the number of branches that do not have a document 2</SPAN></P></BODY></HTML> Thu, 11 Feb 2016 12:36:24 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096456#M466275 2016-02-11T12:36:24Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096457#M466276 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot_2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114317_Screenshot_2.png" style="height: 310px; width: 620px;" /></P></BODY></HTML> Thu, 11 Feb 2016 12:40:31 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096457#M466276 2016-02-11T12:40:31Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096458#M466277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this,</P><P></P><P>Can you explain a bit more ! Your output required.</P><P></P><P>PFA</P><P>Hirish</P></BODY></HTML> Thu, 11 Feb 2016 13:39:35 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096458#M466277 HirisH_V7 2016-02-11T13:39:35Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096459#M466278 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>try this Expression for Branches that do not have Document 2</P><P><STRONG>= count(DISTINCT aggr(count(DISTINCT if(document&lt;&gt;'document2', branch)),branch))</STRONG></P><P></P><P>Please find the attachment </P></BODY></HTML> Thu, 11 Feb 2016 13:53:29 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096459#M466278 sasikanth 2016-02-11T13:53:29Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096460#M466279 <HTML><HEAD></HEAD><BODY><P>Ha, that's not what you asked for though <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 11 Feb 2016 14:56:44 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096460#M466279 awhitfield 2016-02-11T14:56:44Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096461#M466280 <HTML><HEAD></HEAD><BODY><P>HI,<STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/sasikanth_Narne">sasikanth_Narne</A></STRONG></P><P><STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But I added + 1 branch. and now in the table should be "2"<IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114392_Screenshot_3.png" style="height: 338px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Fri, 12 Feb 2016 05:42:53 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096461#M466280 2016-02-12T05:42:53Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096462#M466281 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Try this expression</P><P><STRONG>= count(DISTINCT aggr(count( if(document&lt;&gt;'document2', branch)),branch))</STRONG></P><P>removed DISTINCT inside aggr, just try it.</P><P></P><P></P><P>Pls. see attachement</P></BODY></HTML> Fri, 12 Feb 2016 07:40:43 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096462#M466281 sasikanth 2016-02-12T07:40:43Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096463#M466282 <HTML><HEAD></HEAD><BODY><TABLE class="gt-baf-table" style="color: #777777; font-family: arial, sans-serif; font-size: 13px;"><TBODY><TR><TD colspan="2"><P class="gt-baf-cell gt-baf-word-clickable" style="margin: 1px 0 0 4px; color: #000000; text-decoration: underline;">Thank you</P></TD><TD></TD></TR></TBODY></TABLE><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 12 Feb 2016 07:56:52 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096463#M466282 2016-02-12T07:56:52Z Re: calculation distinct https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096464#M466283 <HTML><HEAD></HEAD><BODY><P>count( {&lt;Column name={'Name'}&gt;}Distinct Documnent2)</P></BODY></HTML> Fri, 12 Feb 2016 07:59:09 GMT https://community.qlik.com/t5/QlikView/calculation-distinct/m-p/1096464#M466283 Anonymous 2016-02-12T07:59:09Z