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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Equals Versus Not Equals - any efficiency difference?

When loading data from a QVD into a QVW with limitations as to what records should be pulled in, is there any difference in efficiency between using equals versus not equals?

Labels (1)
1 Reply
IAMDV
Master II
Master II

Hi,

Sorry, I am not clear with your question. But do you know that you can use the below :

Match (Field,'A','B','C') OR

Not match (Field,'F')

Match() - function is essentially is the same as an "IN" clause in SQL Server.

I hope this makes sense!

Cheers - DV