aggr set analysis query

Wed, 06 May 2015 14:35:06 GMT

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

Re: aggr set analysis query

Wed, 06 May 2015 14:42:23 GMT

Think I;ve solved it actually!

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

topic Re: aggr set analysis query in QlikView

aggr set analysis query

Re: aggr set analysis query