topic Re: Count Expression in QlikView https://community.qlik.com/t5/QlikView/Cnt-Expression/m-p/1093942#M929283 <HTML><HEAD></HEAD><BODY><P>The problem with Distinct count is that it is dependent on your dimension. So it is distinct per your dimension. Look at an example where I have selected one Result.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118357_Capture.PNG" style="height: 373px; width: 620px;" /></P><P></P><P>Now you have to decide that would this be part of SN or SN-HIDE in your Invoice field. Both are correct, but if you want the bar chart's sum to match with sum of straight table's row, one of the two Invoice have to go away, right? Which one would that be?</P></BODY></HTML> Thu, 17 Mar 2016 08:41:13 GMT sunny_talwar 2016-03-17T08:41:13Z Cnt Expression https://community.qlik.com/t5/QlikView/Cnt-Expression/m-p/1093941#M929282 <HTML><HEAD></HEAD><BODY><P>.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cnt-Expression/m-p/1093941#M929282 smilingjohn 2020-11-25T16:16:04Z Re: Count Expression https://community.qlik.com/t5/QlikView/Cnt-Expression/m-p/1093942#M929283 <HTML><HEAD></HEAD><BODY><P>The problem with Distinct count is that it is dependent on your dimension. So it is distinct per your dimension. Look at an example where I have selected one Result.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118357_Capture.PNG" style="height: 373px; width: 620px;" /></P><P></P><P>Now you have to decide that would this be part of SN or SN-HIDE in your Invoice field. Both are correct, but if you want the bar chart's sum to match with sum of straight table's row, one of the two Invoice have to go away, right? Which one would that be?</P></BODY></HTML> Thu, 17 Mar 2016 08:41:13 GMT https://community.qlik.com/t5/QlikView/Cnt-Expression/m-p/1093942#M929283 sunny_talwar 2016-03-17T08:41:13Z