Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatesh61524
Contributor II
Contributor II

count distinct function in pivot table

Dear All,

I have a two columns data serial number and delivery number. Now if we choose one serial number have two same delivery numbers and different delivery number.

Example data want to see in Pivot table:(Requirement)

 

Serial NoDelivery NumberTotal
518012
801
518151
609502
950
609901
8015002
1500
8020001

The above example table .if we select 51 serial number can see three delivery numbers. But in three delivery numbers have two are same one is different for same serial number.now we need to show this data into pivot chart.

i have tried with this expression in pivot chart:

Aggr( Count(Distinct [Delivery Number]),[Serial No],[Delivery Number])

After expression have data in pivot table:

 

Serial NoDelivery NumberTotal
518011
8151
609501
9901
8015001
20001

Please suggest and show the correct expression for my requirement ..

10 Replies
MK_QSL
MVP
MVP

This was a simple problem and you would have got answer within 10 minutes if while posting question, you would have supplied sample application or sample excel file with the result you was  looking for..

Happy Qliking !