Set analysis intersection stopped working - Qlik Community

Report Inappropriate Content · ‎2012-02-19

Greetings Community. I am baffled.

I am using the following set analysis expression to copy the intersection of the possible values in a field across two alternate states to a "Select in Field' Action. The replace is required for values with spaces.


 
 ='(' & replace((concat({[Group 1]*[Group 2]} COMPLEX, '|')), ' ', '?')& ')'

It was working beautifully until several days ago. Now, the insection gives me nothing. I tested other join types and results are not all correct. Union is OK, Difference is incorrect, intersection is blank (not '-'), and XOr looks like a union. (See below) Any ideas what might cause these joins to be incorrect after they once worked?

Thanks for your help! I always mark correct and helpful answers.

Anonymous · ‎2012-02-19

Looking at the expression syntax, I assume that [Group 1] and [Group 2] are bookmarks. Make sure that both bookmarks are working by themselves, and their names are still the same, restore if needed. Otherwise "stopped working" doesn't make much sense...

Anonymous · ‎2012-02-20

Follow-up.
My answer above was based on the assumption that both bookmarks make selections in the same field that you concatenate, "COMPLEX". From your screenshot, it is not the case. That means:
It is not clear what fields are selected by your bookmarks, and how these fields are related to COMPLEX. Moreover, it is not clear what the operations like union, intersection, etc. mean in this case. These operations are not on the COMPLEX field itself but on the unknown selected fields. It is likely that the results you see are "correct", and the "stopped working" situation is simply a result of the data changes after reload.

To get the "expected" result, the bookmarks should make selections in the COMPLEX field, and probably in no other fields.

CELAMBARASAN · ‎2012-02-20

Hi,

As of me your using correct syntax only for achieving results between two alternate states.

Celambarasan

Report Inappropriate Content · ‎2012-02-20

Michael,

Group 1 and Group 2 are named Groups in v11, used to do analysis on two datasets using alternate states. There are other fields in the groups, but my function is only calling for the Intersection of the Complex field from these two states.

Celambarasan,

Thanks for confirming that the syntax is correct. I have found there are some instances where the function is working and others where it is not... more to come.

Nancy