Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Some1
Contributor II
Contributor II

Cumulate unique count

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,

Labels (2)
1 Solution

Accepted Solutions
VBD
Partner - Creator II
Partner - Creator II

2 Replies
VBD
Partner - Creator II
Partner - Creator II

Some1
Contributor II
Contributor II
Author

perfect, thanks!