topic set analysis excluding selections in QlikView

set analysis excluding selections

Anonymous — Mon, 24 Oct 2011 07:26:33 GMT

Hi,

I have the followin expression:

avg(aggr(count({$<Sales={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))

I have this in a chart showing bars for each Team. But when i select a Team only one bar i showing and that's not what i want, the chart must remain the same (hence, showing all teams(bars) despite the selection of team. It worked fine with this expression sum({$<Signt = , Team = , Name= >} Points) so i'm thinking it's the aggr function that doesn't like this.

Any ideas how i solve this?

Thanks!

//A.

Re: set analysis excluding selections

Miguel_Angel_Baeyens — Mon, 24 Oct 2011 07:31:39 GMT

Hi,

At a first glance, you may need to add

avg({1} aggr(count({$<Sales={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))

The {1} part to indicate all possible values. You may try the 1 instead of the $ in the Count() function as well, instead of setting all fields equal to nothing

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

set analysis excluding selections

Anonymous — Mon, 24 Oct 2011 09:20:20 GMT

worked great! Thanks!