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
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shnqqs
Contributor II
Contributor II

Not match function

Hi All Qlickies,

Request help from anyone to enlightened me on Not Macth function. I'm trying to understand how it is working rather than just copy the expression that solved my issue.

So I get below expression to exclude a field in dimension, but I couldn't and didn't find the real understanding on how Not Match is working in this expression.

=If(not Match([Shipment status],'Not shipped yet'), [Shipment status])

 

Thanks in advance for help!

 

1 Solution

Accepted Solutions
Sammy_AK
Creator II
Creator II

See below, Table A is with Match condition where it will show values based on the match condition and where as Table B where not is applied it not show values for match condition but it will show the output for the rest of the table.

Sammy_AK_1-1623320562446.png

 

View solution in original post

2 Replies
Sammy_AK
Creator II
Creator II

See below, Table A is with Match condition where it will show values based on the match condition and where as Table B where not is applied it not show values for match condition but it will show the output for the rest of the table.

Sammy_AK_1-1623320562446.png

 

View solution in original post

shnqqs
Contributor II
Contributor II
Author

Perfectly understood it! Thanks Sammy!