Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
Hi Gysbert,
It works correctly. Thanks for your precious help.
Warm Regards,
Kyaw Myo Tun