topic Re: How Can I remove certain Items || Combine certain items from a List Box in QlikView

How Can I remove certain Items || Combine certain items from a List Box

Mon, 06 Jun 2016 14:40:20 GMT

Hi there,

I try to not to show all the items in a List Box.

For example, the List Box currently shows :

However, I would like to only show certain items, such as,

I can use "Expression" to get rid of only one item, such as "=if(DataField<> 'B',DataField)". But I cannot remove several items. How can I remove several items B, D, F?

Another question is how can I combine centain items into one item?

For example, I want to put "B, D, F" items into a new item which called "Total". How can I achieve this goal?

Thanks in advance,

Becky

Re: How Can I remove certain Items || Combine certain items from a List Box

sunny_talwar — Mon, 06 Jun 2016 14:58:03 GMT

May be this:

If(Not Match(DataField, 'B', 'D', 'F'), DataField, 'Total')

Re: How Can I remove certain Items || Combine certain items from a List Box

sunny_talwar — Mon, 06 Jun 2016 14:59:02 GMT

or like this:

If(DataField <>'B' or DataField = 'D' or DataField = 'F', DataField, 'Total')

Re: How Can I remove certain Items || Combine certain items from a List Box

Anonymous — Mon, 06 Jun 2016 15:01:07 GMT

try this for both of your questions:

the first part will list you the items A,C and E, while B,D,F will be included inTotal

if match(Datafield,'A','C','E')>0, Datafield, 'Total')

Re: How Can I remove certain Items || Combine certain items from a List Box

Kushal_Chawda — Mon, 06 Jun 2016 15:04:38 GMT

=if(match(Field,'B','D','F'),'Total',Field)

Re: How Can I remove certain Items || Combine certain items from a List Box

Mon, 06 Jun 2016 15:04:59 GMT

The one above has error. This solution is working. However, put AND instead of OR in between. Thanks so much Sunny!

Do you know how to group B, D, F into one item?

Re: How Can I remove certain Items || Combine certain items from a List Box

Mon, 06 Jun 2016 15:21:51 GMT

Thanks Rudolf. I believe your solution is the simplest one and great. Thanks so much!! n