Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rebelfox
Creator
Creator

Get a count of unique column values in table

I have a feeling this will be very simple but by throbbing head can't think how to do this.

I have a Table Box with many rows that is effectively order detail lines.

Each row has an order number and a position number.

The position number is not always 1,2,3,4,5.  It can be 3,6,8,9,10 for example.

How can I get dynamically display in a separate statistics or text box the number of distinct order numbers selected in the Table Box?

1 Solution

Accepted Solutions
sunny_talwar

May be this in a text box object

Count(DISTINCT [order number])

View solution in original post

1 Reply
sunny_talwar

May be this in a text box object

Count(DISTINCT [order number])

View solution in original post