Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude lines

Hi All,

I have below straight table in my QV file.

I need to exclude the data where entry date = 20/11/2015 and exclude relative lines on the basis of 'Key'

KeyIDEntry Date
9854694528/10/2015
9854694620/11/2015
456877804/11/2015

Thanks a lot

1 Solution

Accepted Solutions
sunny_talwar

May be this as your set analysis:

{<Key = e({<[Entry Date] = {'20/11/2015'}>})>}


Capture.PNG

View solution in original post

1 Reply
sunny_talwar

May be this as your set analysis:

{<Key = e({<[Entry Date] = {'20/11/2015'}>})>}


Capture.PNG