Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hykal1993
Contributor II
Contributor II

Found an error - please help :(

Hi,

I would like to exclude where all the columns below are No

Capture 1 .PNG

Therefore, I created a new filter using below formula

=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include')

Capture 2.PNG

However, when I filter 'Include', both are selected for some reason.

Capture 4.PNG

Help!

1 Reply
jyothish8807
Master II
Master II

Try this in the script.

Load

*,

=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include') as Filter

from <>


Br,

KC

Best Regards,
KC