count value is different

realpixel — Tue, 02 Apr 2013 08:36:53 GMT

Hello,

I use the function count to count the column 'PEV', it's works fine but I need to count only HCOUNT is different. The value HMCOUNT = U5956123 appears three times and this value is counted three times.

CUSTO	HMCONT	PEV
CUSTO1	U5956123	1
CUSTO1	U5956123	1
CUSTO1	U5956123	1
CUSTO2	U3176658	1
CUSTO2	U3537855	1
CUSTO2	U9180451	1
CUSTO2	U9281210	1
CUSTO2	U2082308	1

see under the result

CUSTO		PEV
CUSTO1		3
CUSTO2		5

Column CUSTO and HMCOUNT have 30 000 rows with different value. How to do to count only once if the value appears several time, like sum product in Excel?

count(PEV)

Re: count value is different

swuehl — Tue, 02 Apr 2013 08:38:19 GMT

try a distinct count

=count(distinct HMCONT)

Re: count value is different

realpixel — Tue, 02 Apr 2013 08:51:13 GMT

Hello Swuehl, thank you for your assistance. It's works!

topic count value is different in QlikView

count value is different

Re: count value is different

Re: count value is different