Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Count occurrences

Hello,

I have a little problem with a counting function.

I try to count the number of customers but only when the number of recorded actions is greater than 2 and the place = 'x'

CustomerplaceActions
A

x

f
Axg
Axh
Azi
Bxf
Bxg
Bxh
Czk
Czl
Cxi
Dxj

in the the table above I would like to count the number of customers where:

- place different from x

- number of actions is greater than 2

So here the result should be 2.

My problem is that I know how to count with conditions

count(distinct if(

     place = 'x',

, Customer) )

but I cannot add a calculation as a condition.

1 Solution

Accepted Solutions
Highlighted

Re: Count occurrences

May be this

Count(DISTINCT {<Customer = {"=Count(DISTINCT {<place = {'x'}>} Actions) > 2"}, place = {'x'}>} Customer)


Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Count occurrences

May be this

Count(DISTINCT {<Customer = {"=Count(DISTINCT {<place = {'x'}>} Actions) > 2"}, place = {'x'}>} Customer)


Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Count occurrences

Seriously thank you !!

this is exactly the solution.