Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

qlik sense - count number of customers make more than x number order per week

Hi

I have been trying to make a count of customers who make 3 or more orders per week

dimension - weekend(OrderDate)

Measure - count(aggr(if(count(distinct OrderID)>3,1), CustomerID))

this works when you select the week ending date, but when you unselected it , over counts the totals

for e.g week I get on the continuous chart 1,035, when I select the week, I get 6 which is the correct number

please help

4 Replies
kaushiknsolanki
MVP & Luminary
MVP & Luminary

Try this Expression.

Count({<CustomerID = {'=Count(Distinct OrderID) >3'}>}CustomerID)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
joeybird
Creator III
Creator III
Author

Hi

sorry this do not work

any more ideas please?

Kind Regards

kerdoncuff
Contributor III
Contributor III

Hi,

add a distinct :

Count(distinct {<CustomerID = {'=Count(Distinct OrderID) >3'}>}CustomerID)

joeybird
Creator III
Creator III
Author

Hi

still no joy

its the same issue

that's why I even tried using the aggr function

any more ideas?

Kind Regards