topic Re: Why do I get an error while finding the following Distinct Count ? in QlikView

Why do I get an error while finding the following Distinct Count ?

Wed, 04 Nov 2015 09:23:59 GMT

I am using this expression to find the distinct count :

" count(distinct[Invoice Number]) "

Where Invoice Number is the Field Name .

Help Me out .

arasantorule — Wed, 04 Nov 2015 10:02:07 GMT

Please use count(distinct([Invoice Number]))

bracket after distinct

Thanks

simospa — Wed, 04 Nov 2015 10:27:46 GMT

Hi,

in first, look at the space between distinct and [

count(distinct [Invoice Number])

Then ensure that [Invoice Number] really have I and N uppercase.

Let us know.

simospa — Wed, 04 Nov 2015 10:30:23 GMT

Ankit: I see you are a Novice.

I remember you to mark correct an answer if it provide you a solution to your issue.

Thanks

Kushal_Chawda — Wed, 04 Nov 2015 10:33:05 GMT

Try,

count(distinct [Invoice Number])

Wed, 04 Nov 2015 10:59:00 GMT

Thanks a Lot This worked

simospa — Wed, 04 Nov 2015 11:16:59 GMT

Then mark as "correct answer" the answer. It might help others in the future 🙂