Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Count Distinct if Sum of Count Greater Than

Hi,

I am trying to write a formula that will give me the count of IP addesses in a table where the number of occurences of that IP is over 300. I would like to put that into a text box formula so that the figure is highlighted on my dashboard. I am able to display the actual list of IPs where this occurs with the formula below within a Pivot table that has IP selected as a dimension:

=if(sum(recordcount)>300,count(IP))

In the end there are 26 IPs out of about 3000 that come up over 300 times in the pivot, I would the textbox to display 26. Any help at all would be appreciated.

Thanks.

SS

1 Solution

Accepted Solutions
Highlighted
swuehl
Not applicable

Re: Count Distinct if Sum of Count Greater Than

In a text box, try

=COUNT({< IP = {"=count(IP)>300"} >} DISTINCT IP)

2 Replies
Highlighted
swuehl
Not applicable

Re: Count Distinct if Sum of Count Greater Than

In a text box, try

=COUNT({< IP = {"=count(IP)>300"} >} DISTINCT IP)

Not applicable

Re: Count Distinct if Sum of Count Greater Than

That was just what I needed. Thanks for the quick help.