Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator 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
sunny_talwar

Try this

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

or this

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

View solution in original post

1 Reply
sunny_talwar

Try this

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

or this

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