Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
infosense_devel
Contributor II

Aggregation issue in expression.

Hello,

     my desire result given in below table.

    

Customer NameCustomer NumberCountry Country Count
a1001USA2
a1001China2
b1002USA1
c1003Spain4
c1003USA4
c1003China4
c1003Italy4

for Country Count i am using below expression but it is not working for me.

=Aggr(Count(Country ),Customer Name,Customer Number)

it is showing data as below for customer "a".

    

Customer NameCustomer NumberCountry Country Count
a1001USA0
a1001China2

Thanks in advance.

1 Solution

Accepted Solutions

Re: Aggregation issue in expression.

Try this

Count(DISTINCT TOTAL <[Customre Name]> Country)

or this

=Aggr(NODISTINCT Count(DISTINCT Country),Customer Name,Customer Number)

1 Reply

Re: Aggregation issue in expression.

Try this

Count(DISTINCT TOTAL <[Customre Name]> Country)

or this

=Aggr(NODISTINCT Count(DISTINCT Country),Customer Name,Customer Number)