Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Match and Exclude

Hello,

 

Im looking to add another condition to the formula below: [Extended Leave]='1', but have not been successful.

=if( Match([Work Type],'Generic-Full','ESS II',',[Work Type])

 

Thank you

1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

im not sure but try below.

if( not Match([Work Type],'Generic-Full','ESS II') or  [Extended Leave]='1',[Work Type])

'or

 

if( not Match([Work Type],'Generic-Full','ESS II') and  [Extended Leave]='1',[Work Type])

View solution in original post

5 Replies
Chanty4u
Champion III
Champion III

try this

if( Match([Work Type],'Generic-Full','ESS II') or  [Extended Leave]='1',[Work Type])

danieldors
Contributor III
Contributor III

Adding the or [Extended Leave]='1', worked in excluding those who are on extended leave but included all the other work types. I'm trying to exclude those on extended leave under the work types Generic Full and ESSII only.

Chanty4u
Champion III
Champion III

im not sure but try below.

if( not Match([Work Type],'Generic-Full','ESS II') or  [Extended Leave]='1',[Work Type])

'or

 

if( not Match([Work Type],'Generic-Full','ESS II') and  [Extended Leave]='1',[Work Type])

View solution in original post

danieldors
Contributor III
Contributor III

Without the Not it worked. Thank you.

 

if( Match([Work Type],'Generic-Full','ESS II') and  [Extended Leave]='1',[Work Type])

Chanty4u
Champion III
Champion III

cool 🙂   can you close this thread by making accept as solution.

 

 

best

chanty