topic Re: Count Distinct in QlikView https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127338#M462861 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=count(Total DIM_02)</SPAN></P></BODY></HTML> Wed, 17 Aug 2016 20:48:11 GMT trdandamudi 2016-08-17T20:48:11Z Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127337#M462860 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the image bellow I'm doing a count Distinct over DIM_02.</P><P>As you can see, the TOTAL is 4 because there's 4 different values for DIM_02.</P><P>But now I need to show in a bar chart the sum of the totals, like in the second image.</P><P></P><P>Expression: </P><P>=count(DISTINCT DIM_02)</P><P></P><P><IMG alt="01.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134795_01.JPG" style="height: auto;" /><IMG alt="02.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/134796_02.JPG" style="height: auto;" /></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 17 Aug 2016 20:43:52 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127337#M462860 2016-08-17T20:43:52Z Re: Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127338#M462861 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=count(Total DIM_02)</SPAN></P></BODY></HTML> Wed, 17 Aug 2016 20:48:11 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127338#M462861 trdandamudi 2016-08-17T20:48:11Z Re: Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127339#M462862 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Count(DISTINCT Dim_01 &amp; Dim_02)</P></BODY></HTML> Wed, 17 Aug 2016 20:54:15 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127339#M462862 swuehl 2016-08-17T20:54:15Z Re: Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127340#M462863 <HTML><HEAD></HEAD><BODY><P>Remove Dim_01 from you dimension tab and see ?</P></BODY></HTML> Wed, 17 Aug 2016 20:55:47 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127340#M462863 vishsaggi 2016-08-17T20:55:47Z Re: Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127341#M462864 <HTML><HEAD></HEAD><BODY><P>Perfect, Stefan!</P><P>Thank you very much!</P></BODY></HTML> Wed, 17 Aug 2016 20:58:51 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/1127341#M462864 2016-08-17T20:58:51Z