topic Re: Count and distinct with conditions in QlikView https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384034#M143381 <HTML><HEAD></HEAD><BODY><P>Thnx this is what i mean!</P></BODY></HTML> Wed, 05 Sep 2012 04:52:56 GMT francisvandergr 2012-09-05T04:52:56Z Count and distinct with conditions https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384032#M143379 <HTML><HEAD></HEAD><BODY><P>I have a question. I include an example of what i want. I try to explain it also here. I have a dimension group on my dashboard. In the expression i have a count of debno. But it may only count if the debno is not in another group. The debno's who are in more groups must be named in the group "Multiple".</P><P></P><P>Is this possible with qlikview ?</P></BODY></HTML> Tue, 04 Sep 2012 18:32:38 GMT https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384032#M143379 francisvandergr 2012-09-04T18:32:38Z Re: Count and distinct with conditions https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384033#M143380 <HTML><HEAD></HEAD><BODY><P>I think yes.</P><P>See attached, or apply the following expression in your "table 2"</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13467879298465909" jivemacro_uid="_13467879298465909"><P>sum(aggr(if(count(DISTINCT Group)=1,1,0),Debno))</P></PRE><P></P><P></P><P>That expression will per group, count only those DebNo's where they are only in 1 group.</P><P></P><P>I think, in the same chart you cannot add "multiple" as a line...</P><P>A solution can be to place a textbox somewhere, where the "multiple" value is calculated.</P><P></P><P>This is the expression for the textbox to calculate the "multiple group debo's"</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13467880507364309" jivemacro_uid="_13467880507364309"><P>sum(aggr(if(count(DISTINCT Group)&gt;1,1,0),Debno)) </P></PRE><P></P><P>See attached QVW where I applied those formula's. </P><P></P><P>Hope it helps.</P></BODY></HTML> Tue, 04 Sep 2012 19:49:15 GMT https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384033#M143380 2012-09-04T19:49:15Z Re: Count and distinct with conditions https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384034#M143381 <HTML><HEAD></HEAD><BODY><P>Thnx this is what i mean!</P></BODY></HTML> Wed, 05 Sep 2012 04:52:56 GMT https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384034#M143381 francisvandergr 2012-09-05T04:52:56Z Re: Count and distinct with conditions https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384035#M143382 <HTML><HEAD></HEAD><BODY><P>You're welcome!</P><P></P><P>Happy Qlikviewing!</P></BODY></HTML> Wed, 05 Sep 2012 08:16:18 GMT https://community.qlik.com/t5/QlikView/Count-and-distinct-with-conditions/m-p/384035#M143382 2012-09-05T08:16:18Z