topic Get a count of unique column values in table in QlikView https://community.qlik.com/t5/QlikView/Get-a-count-of-unique-column-values-in-table/m-p/114241#M762277 <HTML><HEAD></HEAD><BODY><P>I have a feeling this will be very simple but by throbbing head can't think how to do this.</P><P>I have a Table Box with many rows that is effectively order detail lines. </P><P>Each row has an order number and a position number.</P><P>The position number is not always 1,2,3,4,5.&nbsp; It can be 3,6,8,9,10 for example.</P><P></P><P>How can I get dynamically display in a separate statistics or text box the number of distinct order numbers selected in the Table Box?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT rebelfox 2020-11-25T16:16:04Z Get a count of unique column values in table https://community.qlik.com/t5/QlikView/Get-a-count-of-unique-column-values-in-table/m-p/114241#M762277 <HTML><HEAD></HEAD><BODY><P>I have a feeling this will be very simple but by throbbing head can't think how to do this.</P><P>I have a Table Box with many rows that is effectively order detail lines. </P><P>Each row has an order number and a position number.</P><P>The position number is not always 1,2,3,4,5.&nbsp; It can be 3,6,8,9,10 for example.</P><P></P><P>How can I get dynamically display in a separate statistics or text box the number of distinct order numbers selected in the Table Box?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-a-count-of-unique-column-values-in-table/m-p/114241#M762277 rebelfox 2020-11-25T16:16:04Z Re: Get a count of unique column values in table https://community.qlik.com/t5/QlikView/Get-a-count-of-unique-column-values-in-table/m-p/114242#M762278 <HTML><HEAD></HEAD><BODY><P>May be this in a text box object</P><P><STRONG>Count(DISTINCT [order number])</STRONG></P></BODY></HTML> Tue, 07 Aug 2018 13:07:12 GMT https://community.qlik.com/t5/QlikView/Get-a-count-of-unique-column-values-in-table/m-p/114242#M762278 sunny_talwar 2018-08-07T13:07:12Z