Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
SamWeatherby
Contributor
Contributor

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

1 Solution

Accepted Solutions
sasikanth
Master
Master

try below one

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

View solution in original post

1 Reply
sasikanth
Master
Master

try below one

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

View solution in original post