Finding a column value that doesn't match one or more other column values

[SamWeatherby]

Hi Qlik Community

First time questioner, long time reader here.

I'm wondering if there is an equivalent to a 'not in' statement for a qlikview expression. E.g. I have a date in column A plus a 6 month target date and 12 month target date in columns B and C, respectively. I need to be able to highlight anyone who's date in column A doesn't match the date in either B or C.

Something along that lines of this which isn't current working:

[DoNotOfferBeforeDate]  not in ([6MTarget],[12MTarget])

The alternative being creating a flag for this in my load script but just wondered if this was possible from the expression

[sasikanth · Accepted solution]

try below one

[DoNotOfferBeforeDate]<> [6MTarget] and [DoNotOfferBeforeDate]<>[12MTarget]