Finding a column value that doesn't match one or more other column values
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