topic Re: Distinct Count set Analysis ignore any selections in QlikView https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846629#M1001541 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">=count({1&lt;[Hospital Desc] =$::[Hospital ]&gt;} DISTINCT PK_ADMISSION)</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 00:32:34 GMT shaan007 2015-06-18T00:32:34Z Distinct Count set Analysis ignore any selections https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846626#M1001534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have an admission data model with many tables.</P><P>When I calculate a KPI (in text Object)</P><P>=count(PK_ADMISSION) returns 17,564 which is correct PK_ADMISSION&nbsp; has one to many links in the data model</P><P>=count(DISTINCT PK_ADMISSION) im getting a value <SPAN style="font-size: 13.3333330154419px;">35,747</SPAN> which is correct</P><P></P><P>=count({1} DISTINCT PK_ADMISSION) returns 35,747</P><P></P><P>how do i Count Distinct value of a selected Field (Hospital) while ignore all other selections?</P></BODY></HTML> Thu, 18 Jun 2015 00:14:55 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846626#M1001534 shaan007 2015-06-18T00:14:55Z Re: Distinct Count set Analysis ignore any selections https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846627#M1001537 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=count({1} DISTINCT PK_ADMISSION) should be correct</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Would you mind sharing your app? <A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Thu, 18 Jun 2015 00:16:36 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846627#M1001537 Clever_Anjos 2015-06-18T00:16:36Z Re: Distinct Count set Analysis ignore any selections https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846628#M1001539 <HTML><HEAD></HEAD><BODY><P>A "brute force" approach is creating an Alternate State and putting that text box in that state with <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=count(DISTINCT PK_ADMISSION)&nbsp; as expression</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 00:18:17 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846628#M1001539 Clever_Anjos 2015-06-18T00:18:17Z Re: Distinct Count set Analysis ignore any selections https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846629#M1001541 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">=count({1&lt;[Hospital Desc] =$::[Hospital ]&gt;} DISTINCT PK_ADMISSION)</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 00:32:34 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-set-Analysis-ignore-any-selections/m-p/846629#M1001541 shaan007 2015-06-18T00:32:34Z