Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
geam1988
Creator
Creator

order number count

Sales:

LOAD [Order Number],

     Product,

     Year

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);


i want to see how many Order Number is there .

i am using Count (Order Number) in expressions it shows 5 . actually i want to see the result as 3 because 100 is 3 times with different product.   what should i do ?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Did you try:

= Count(DISTINCT [Order Number])

View solution in original post

3 Replies
konradmy
Contributor
Contributor

Hi,

try using DISTINCT inside your Count function to count only distinct values. In this example: Count (Distinct [Order Number])

vishsaggi
Champion III
Champion III

Did you try:

= Count(DISTINCT [Order Number])

View solution in original post

geam1988
Creator
Creator
Author

Thanks