Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vinaykotha
New Contributor

Where Condition in List Box

Hello,

I have 2 Fields ID & Description. There are 8 ID's from 1 to 8 and have descriptions for each ID. I do now want to show ID 6 in the list. Could someone please help me in writing the Where condition in the List Box. I tried several combinations but it is not working.

Thanks

Vinay K

1 Solution

Accepted Solutions

Re: Where Condition in List Box

May be like this

If(ID <> 6, ID)

or

Aggr(Only({1<ID =-{6}>} ID), ID)

2 Replies

Re: Where Condition in List Box

May be like this

If(ID <> 6, ID)

or

Aggr(Only({1<ID =-{6}>} ID), ID)

vinaykotha
New Contributor

Re: Where Condition in List Box

Thank you, it worked.