topic Re: Count a column value only once in QlikView

Count a column value only once

Fri, 26 Aug 2011 12:19:53 GMT

Hi,

Can someone help me with an expression problem. I need to make a count expression to count a value only once, even if it is present in the column several times? Also i would have to do it the other way around, count line items.

Name Orders

Gary 10

Gary 25

Eli 30

Shawn 45

Appreciate the help.. learning slowly.

Count a column value only once

Fri, 26 Aug 2011 12:24:44 GMT

count (Distinct name)

Re: Count a column value only once

SunilChauhan — Fri, 26 Aug 2011 13:14:44 GMT

see the attched file

Re: Count a column value only once

Fri, 26 Aug 2011 13:20:46 GMT

Sorry but i am still waiting for my Named Cal license.. Could you post the expression?

Thanks for the help.

Count a column value only once

SunilChauhan — Fri, 26 Aug 2011 13:45:55 GMT

in dimension select name

and in expression write

count(distinct Name)