Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sum based on count

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

1 Solution

Accepted Solutions

Re: Sum based on count

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))


talk is cheap, supply exceeds demand
2 Replies

Re: Sum based on count

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))


talk is cheap, supply exceeds demand
Not applicable

Re: Sum based on count

Hi Gysbert,

            It works correctly. Thanks for your precious help.

Warm Regards,

Kyaw Myo Tun

Community Browser