topic Re: Total count in QlikView

Total count

samuel_brierley — Wed, 11 Sep 2013 09:26:50 GMT

Hi can someone lend some hep,

Im looking for an expression that will count how mnay times an address occurs in a set of data,

=count([device address] )

=count(total([device address]))

both give the same number which is a count of how mnay times that address is found in the row which obviosuly is just one

Gysbert_Wassenaar — Wed, 11 Sep 2013 09:29:53 GMT

count( total [device address]) will show the total number of addresses that are possible with the current selections.

If you want to ignore selections you need count({1} total [device address])

See this blog post for more information: The Aggregation Scope

gines_rueda — Wed, 11 Sep 2013 09:30:57 GMT

Could you try with this ?

=COUNT ( DISTINCT [device address] )

Sokkorn — Wed, 11 Sep 2013 09:31:08 GMT

Hi Samuel,

Did you try this yet:

=count(TOTAL [device address]) OR

=count({1} [device address])

Regards,

Sokkorn

Wed, 11 Sep 2013 09:39:15 GMT

if you try this

=count([device address] ) // then this code also count the duplicate value

=count(total([device address])) // then this code also count the duplicate value on selection

if you try this

=count( distinct [device address] ) //then this code count only distinct value

=count(distinct total[device address] ) // then this code count only distinct value on selection