topic Re: order number count in QlikView

order number count

geam1988 — Sun, 22 Jul 2018 13:02:56 GMT

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 ?

Re: order number count

Anonymous — Sun, 22 Jul 2018 13:30:19 GMT

Hi,

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

Re: order number count

vishsaggi — Sun, 22 Jul 2018 14:32:08 GMT

Did you try:

= Count(DISTINCT [Order Number])

Re: order number count

geam1988 — Sun, 22 Jul 2018 14:44:31 GMT

Thanks