topic Re: Drill Down Group in QlikView

Drill Down Group

evansabres — Fri, 23 Feb 2018 18:49:32 GMT

I have a drill down group called 'Menu Drill'

In the group, there is a field called fmlyGRP. I want to use this filed but exclude two possible values.

I attempted to use =IF(fmlyGRP <> 'Condiments' or fmlyGRP <> 'Food Preps', fmlyGRP) with the expected output that those two values would not be displayed, however, this is not functioning.

Re: Drill Down Group

sunny_talwar — Fri, 23 Feb 2018 18:51:28 GMT

May be try this

=IF(fmlyGRP <> 'Condiments' and fmlyGRP <> 'Food Preps', fmlyGRP)

Re: Drill Down Group

sunny_talwar — Fri, 23 Feb 2018 18:52:10 GMT

Or just this

If(not Match(fmlyGRP, 'Condiments', 'Food Preps'), fmlyGRP)