topic Re: Distinct(count) in QlikView https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865004#M989514 <HTML><HEAD></HEAD><BODY><P>I definitely over thought that one. Thank you!</P></BODY></HTML> Mon, 13 Jul 2015 21:42:43 GMT 2015-07-13T21:42:43Z Distinct(count) https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865002#M989512 <HTML><HEAD></HEAD><BODY><P>Hi, <IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92742_Capture.JPG" style="height: 379px; width: 620px;" /></P><P></P><P>So the above is what I have right now. The bottom table is fine, but I need to change the first one. Instead of counting how many days were spent in each status, I want to count how many sales doc #s spent any amount of time in those statuses. For example, if 10 sales doc spent 2 days each in Delivery Block, it would say 10 next to delivery block. I was trying to use aggr and count but I am having trouble getting the expression right. The first one is a straight table and the second is a pivot table.</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 13 Jul 2015 21:34:58 GMT https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865002#M989512 2015-07-13T21:34:58Z Re: Distinct(count) https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865003#M989513 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P>=Count( Distinct [Sales Doc.]) </P></BODY></HTML> Mon, 13 Jul 2015 21:38:34 GMT https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865003#M989513 swuehl 2015-07-13T21:38:34Z Re: Distinct(count) https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865004#M989514 <HTML><HEAD></HEAD><BODY><P>I definitely over thought that one. Thank you!</P></BODY></HTML> Mon, 13 Jul 2015 21:42:43 GMT https://community.qlik.com/t5/QlikView/Distinct-count/m-p/865004#M989514 2015-07-13T21:42:43Z