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

[joeybird]

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

[kaushiknsolanki]

Try this Expression.

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

Regards,

Kaushik Solanki

[joeybird]

Hi

sorry this do not work

any more ideas please?

Kind Regards

[Anonymous]

Hi,

add a distinct :

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

[joeybird]

Hi

still no joy

its the same issue

that's why I even tried using the aggr function

any more ideas?

Kind Regards