topic P/E in set analysis clarification in App Development

P/E in set analysis clarification

ManuelLindekeit — Mon, 08 Jun 2020 20:50:37 GMT

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 *;

Re: P/E in set analysis clarification

jwjackso — Mon, 08 Jun 2020 21:16:08 GMT

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

Re: P/E in set analysis clarification

ManuelLindekeit — Mon, 08 Jun 2020 21:20:46 GMT

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

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

Re: P/E in set analysis clarification

jwjackso — Mon, 08 Jun 2020 21:36:38 GMT

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.

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.