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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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!