topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Tue, 28 Oct 2014 00:18:46 GMT

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?

Re: Set Analysis Problem

Tue, 28 Oct 2014 00:26:43 GMT

Don't worry, i found a fix

This is what worked for me:

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

Re: Set Analysis Problem

Tue, 28 Oct 2014 00:31:07 GMT

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.