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: 
Not applicable

Set Analysis Problem

Hi,

I need to filter an object where QMTXT begins with "INST " and where QMTXT does not contain "DEMO", "UPGRADE" or "WP ".

Here is my code....

{$<QMTXT={"INST *"}, QMTXT-={"*DEMO*", "*UPGRADE*", "*WP *"}>}

The problem is, when i lay it out as above, the first selection QMTXT={"INST *"} does not work. However, when i place the second selection before the first, this problem is reversed. Only the last selection in the code ever works. I think this may be a problem to do with using the same columns in the same set analysis. I am thinking that, for some reason, the last selection overwrites the previous one.

How do i get around this?

2 Replies
Not applicable
Author

Don't worry, i found a fix

This is what worked for me:

QMTXT={"INST *"} - {"*DEMO*", "*UPGRADE*", "*WP *"}

Not applicable
Author

This is exactly what you need 🙂

if you have same field listed multiple times as set modifiers the last one overwrites previous ones.

what you need set operators +, - or * over different sets for same field.