topic Re: Sum based on count in QlikView

Sum based on count

Thu, 02 Jul 2015 08:13:42 GMT

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

Re: Sum based on count

Gysbert_Wassenaar — Thu, 02 Jul 2015 15:19:47 GMT

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

Re: Sum based on count

Fri, 03 Jul 2015 08:20:47 GMT

Hi Gysbert,

It works correctly. Thanks for your precious help.

Warm Regards,

Kyaw Myo Tun