topic Re: Cumulate unique count in App Development

Cumulate unique count

Some1 — Mon, 17 Mar 2025 08:39:01 GMT

Hi all,

I have a chart showing the number of unique customers that have placed an order by month, since the year start. I'm doing:

RangeSum(Above(Count(DISTINCT idClient), 0, RowNo(TOTAL)))

but if a customer has placed orders both e.g. in Jan and Feb, it is counted twice, while it should be counted only once, in the first order month. I need to preserve filtering and drill-down, so I cannot create a column in the script.
Any suggestions?
Many thanks,

Re: Cumulate unique count

VBD — Mon, 17 Mar 2025 08:57:23 GMT

Hello, maybe this can help you :

https://community.qlik.com/t5/Visualization-and-Usability/Help-with-cumulative-distinct-counting/td-p/1662579

Re: Cumulate unique count

Some1 — Mon, 17 Mar 2025 10:06:30 GMT

perfect, thanks!