Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ticiana_Justa
Contributor II
Contributor II

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

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:

pessoas.pngalunos.png

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:

formulas.png

Could you help me?

Best regards

Ticiana Justa

8 Replies
lorenzoconforti
Specialist II
Specialist II

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
Contributor II
Contributor II
Author

Thanks Lorenzo,

I worked

😀

lorenzoconforti
Specialist II
Specialist II

No problem. Please mark the thread as closed

 

Lorenzo

Ticiana_Justa
Contributor II
Contributor II
Author

😁  I thought it worked

but got that result by the qlik

resultado.PNG

simply ignored my set analisys..tried withou % too

Ticiana_Justa
Contributor II
Contributor II
Author

I dont know..

How do I verify that?

lorenzoconforti
Specialist II
Specialist II

Can you post a screenshot of the data model viewer?

Ticiana_Justa
Contributor II
Contributor II
Author

Sorry, I guess i can´t.

 

lorenzoconforti
Specialist II
Specialist II

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