Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try below one
[DoNotOfferBeforeDate]<> [6MTarget] and [DoNotOfferBeforeDate]<>[12MTarget]
try below one
[DoNotOfferBeforeDate]<> [6MTarget] and [DoNotOfferBeforeDate]<>[12MTarget]