topic Ignore dimension selections for GetPossibleCount() in QlikView https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623230#M545060 <HTML><HEAD></HEAD><BODY><P><STRONG>Hi</STRONG></P><P></P><P>Is it possible to ignore the selections on a dimension for <EM>GetPossibleCount()</EM>&nbsp; ?</P><P></P><P><EM>GetPossibleCount()</EM> is not a aggregation function so simple Set Analysis is not valid.&nbsp; If it was valid I would use something like the below</P><P></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM>GetPossibleCount ( { &lt;[Dim1]=&gt;}&nbsp;&nbsp; [Dim2] ) )</EM></SPAN></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM><BR /></EM></SPAN></P><P>Any suggestion for something that is valid ?</P><P></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill Markham</STRONG></P></BODY></HTML> Thu, 10 Apr 2014 09:11:20 GMT Anonymous 2014-04-10T09:11:20Z Ignore dimension selections for GetPossibleCount() https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623230#M545060 <HTML><HEAD></HEAD><BODY><P><STRONG>Hi</STRONG></P><P></P><P>Is it possible to ignore the selections on a dimension for <EM>GetPossibleCount()</EM>&nbsp; ?</P><P></P><P><EM>GetPossibleCount()</EM> is not a aggregation function so simple Set Analysis is not valid.&nbsp; If it was valid I would use something like the below</P><P></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM>GetPossibleCount ( { &lt;[Dim1]=&gt;}&nbsp;&nbsp; [Dim2] ) )</EM></SPAN></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM><BR /></EM></SPAN></P><P>Any suggestion for something that is valid ?</P><P></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill Markham</STRONG></P></BODY></HTML> Thu, 10 Apr 2014 09:11:20 GMT https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623230#M545060 Anonymous 2014-04-10T09:11:20Z Re: Ignore dimension selections for GetPossibleCount() https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623231#M545061 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P><SPAN style="color: #993300;"><EM>Count ( { &lt;[Dim1]=&gt;}&nbsp; <STRONG>Distinct&nbsp; </STRONG>[Dim2] ) </EM></SPAN></P></BODY></HTML> Thu, 10 Apr 2014 09:15:59 GMT https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623231#M545061 tresB 2014-04-10T09:15:59Z Re: Ignore dimension selections for GetPossibleCount() https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623232#M545062 <HTML><HEAD></HEAD><BODY><P>Many thanks, that works perfectly.</P></BODY></HTML> Thu, 10 Apr 2014 10:02:04 GMT https://community.qlik.com/t5/QlikView/Ignore-dimension-selections-for-GetPossibleCount/m-p/623232#M545062 Anonymous 2014-04-10T10:02:04Z