Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
MVP
MVP

Re: Count Distinct if Sum of Count Greater Than

In a text box, try

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

2 Replies
Highlighted
MVP
MVP

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.