Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
Showing results for 
Search instead for 
Did you mean: 

Help with Alternate States and Set Operators

Hey guys,

Great Community! I've learned a ton reading through other's post's and answers. Hopefully someone can help me with this.

If I load 2 tables that join by an ID but have ID sets that don't overlap fully, the extra IDs from the second table seem to be ignored when using set operators on alternate states. I've attached an example file showing the inconsistency.

It seems like I could get around this behavior by doing some fancy loading (force the 2 tables together, or add the IDs from the second table to the first table, etc.) But I'd like to understand why this happens in the first place. Since it seems like in a normal application if I loaded tables that weren't perfectly matched in the wrong order I'd end up with this issue. Any ideas on how to solve this with out doing fancy loading stuff?

1 Reply
Contributor II
Contributor II

Re: Help with Alternate States and Set Operators


I think that I solved the problem, but I can`t figured out why the xor wasn`t working whit your set analyses. To be honest I`m curious about it too.

I just concatenate the tables and create an alias to find out which table is from the value of ValB.


If you found the answer why the xor isn`t working, share whit us.