Aggr() function | Qlik Community

[raviityou]

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

[Gysbert_Wassenaar]

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

[maxgro]

do you mean

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

or

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

instead of

=aggr(Only(Level), Level)

?

[raviityou · Accepted solution]

Thanks Guys  for replay,

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