Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

filter has to be avoided in the list box

=aggr(only({<dept=>}name),name)

this is not working fine in the list box expression which is not excluding the dept

5 Replies
Highlighted

Re: filter has to be avoided in the list box

So you mean that if something is selected in dept, name should not be filtered out? To do this, you would need to use an alternate state. I don't think this will work here

Highlighted
Creator II
Creator II

Re: filter has to be avoided in the list box

Hi Manoranjan,

can you elaborate your question please or sample  ?

Thanks

Kumar kvp

Highlighted
Creator III
Creator III

Re: filter has to be avoided in the list box

so this expression will not work?

only by alternate state only it ll work?

Highlighted

Re: filter has to be avoided in the list box

If what I described above is what you want, then I don't think it will work without alternate state

Highlighted
MVP & Luminary
MVP & Luminary

Re: filter has to be avoided in the list box

Hi,

Can you explain your problem with example and possibly sample data.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".