Sum based on count

[#1]

Hi Experts,

             I am a new one to QlikView. I am trying to understand is the sum value based on count. For Exp; A shop want to know how many customers come to it based on a date. Let me know what functions need to use to get the answers?

Regards,

Kyaw Myo Tun

[Gysbert_Wassenaar · Accepted solution]

Select a data and count the customers: count(distinct customers)

If you want the sum of the counts of each date use something like: sum(aggr(count(distinct customer),date,shop))

[#3]

Hi Gysbert,

            It works correctly. Thanks for your precious help.

Warm Regards,

Kyaw Myo Tun