topic Aggr() function | Qlik Community in QlikView

Aggr() function | Qlik Community

raviityou — Fri, 13 Mar 2015 07:07:35 GMT

Aggr() function | Qlik Community

How we can show only selection related filed in list box , i can achieve whit aggr () but, want if i select any one from them it should not be disappear other like normal list box.

Shared with Jive Anywhere

http://community.qlik.com/thread/38796

Re: Aggr() function | Qlik Community

Gysbert_Wassenaar — Fri, 13 Mar 2015 18:09:08 GMT

I'm afraid I don't understand your question. Can you show us what you want?

Re: Aggr() function | Qlik Community

maxgro — Fri, 13 Mar 2015 18:33:38 GMT

do you mean

=aggr(Only({1}Level),Level)

=aggr(Only({$ <Level=>}Level),Level)

instead of

=aggr(Only(Level), Level)

Re: Aggr() function | Qlik Community

raviityou — Wed, 25 Mar 2015 10:08:57 GMT

Thanks Guys for replay,

got the solution of it =Aggr(Only({<Region=p(Region),Region>}Region),Region)