Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr set analysis query

Hi all,

I have an expression as follows:

count(distinct aggr(if(sum(AnnRevs) > vAnnREVsSlider,[Client]),[Client]))

Basically, if a client has a larger Revenue than the current slider value, count the client.

This is within a text box*

The problem is, I want to not have the number change once a client is selected.

e.g. if 100 clients have AnnRevs > 100, I want the value in the text box to remain at 100 when one client is selected.  I've tried various forms of set analysis with no luck.

Any ideas?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Think I;ve solved it actually!

sum({<[Client] = >}if(aggr({<[Client] = >}sum({<[Client] = >}(AnnRevs) [Client]) > vAnnREVsSlider,1))

View solution in original post

1 Reply
Not applicable
Author

Think I;ve solved it actually!

sum({<[Client] = >}if(aggr({<[Client] = >}sum({<[Client] = >}(AnnRevs) [Client]) > vAnnREVsSlider,1))