Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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