How to get a subset using another set as reference (Intersection)

[Ticiana_Justa]

Hello, I need to make some operations with fields but with only  with a subset of the initial set, this subset must be  based on values of  a field  on another set just like below:

I need to get a subset of table Pessoas wich have the same  %CodMunicipe_pes wich  that are in table Aluno to make some operations, ive tried in severals ways but didnt work . Some ways i´ve tried:

Could you help me?

Best regards

Ticiana Justa

[lorenzoconforti]

Try this:

{<Pessoas.%CodMunicipe_pes = p(Aluno.%CodMunicipe_pes)>}

Are the tables fully qualified? I'm asking because, based on your screenshot, they do not appear to be so (which would be really strange). Syntax highlighting is colouring the table name in black rather than in the amber colour 

[Ticiana_Justa]

Thanks Lorenzo,

I worked

😀

[lorenzoconforti]

No problem. Please mark the thread as closed

Lorenzo

[Ticiana_Justa]

😁  I thought it worked

but got that result by the qlik

simply ignored my set analisys..tried withou % too

[Ticiana_Justa]

I dont know..

How do I verify that?

[lorenzoconforti]

Can you post a screenshot of the data model viewer?

[Ticiana_Justa]

Sorry, I guess i can´t.

[lorenzoconforti]

without data, just the model viewer so that we can see how all fields are mapped and how tables are structured