Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ManuelLindekeit
Contributor III
Contributor III

P/E in set analysis clarification

Hi Experts, 

I'm trying to wrap my head around P/E. I understand its purpose and have looked through conversations and Qlik help. 

Why does below code return David, John, Joseph, but not Peter? 

Concat({$<[Scores.Name] = E({1<[Scores.Sport]={'Tennis'}>})>}Distinct [Scores.Name], CHR(10))

Similarly, why is Thomas not in the list for below? 

Concat({$<[Scores.Name] = E({1<[Scores.Sport]={'Tennis'}>})>}Distinct [Scores.Name], CHR(10))

Attaching excel file with data. 

Qualify *;
Scores:
LOAD
Name,
Sport,
Score
FROM [lib://Desktop (cp_manuel.lindekeit)/Scores.xlsx]
(ooxml, embedded labels, table is Sheet1);

UnQualify *;

 

 

 

 

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

I do show Peter with your data and function.  Thomas would not appear because he does have Tennis as a sport.

e_function.PNG

View solution in original post

3 Replies
jwjackso
Specialist III
Specialist III

I do show Peter with your data and function.  Thomas would not appear because he does have Tennis as a sport.

e_function.PNG

ManuelLindekeit
Contributor III
Contributor III
Author

That's strange. I don't get Peter.

Sorry the question for Thomas was for the case of changing the E for a P. 

ManuelLindekeit_0-1591651209257.png

 

jwjackso
Specialist III
Specialist III

I displayed my results in a Text Box.  When I display it in a table like you, it does not appear.  In the image below, see the difference between using a Chr(10) vs '|'.  Your expression is correct.

e_function.PNG

It looks like the table does not handle the line-feed well.  If you export the data, you will see David, John, Joseph and Peter.