Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
evansabres
Valued Contributor

Drill Down Group

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.

1 Solution

Accepted Solutions
Highlighted

Re: Drill Down Group

May be try this

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

View solution in original post

2 Replies
Highlighted

Re: Drill Down Group

May be try this

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

View solution in original post

Highlighted

Re: Drill Down Group

Or just this

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