Discussion Board for collaboration on QlikView Scripting.
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?
Kyaw Myo Tun
Go to 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))
It works correctly. Thanks for your precious help.