Use Exists function in set expression

[ZoharB]

Hi,

I have the following problem for which I couldn't find an answer:

Simply put I have two tables, say:
Table A:
Load
F1, F2, F3
from (some QVD table);

Table B:
Load M1, M2, M3
From (another QVD table);

I want to show a KPI:
=count({$}<exists(F1 in table B)>)F2

That is I want to show how many F2 I have in table A where F1 exists in Table B (usually in the coloumn M1).

What is the best way to achieve this?
Thanks,

Zohar.

[Or · Accepted solution]

Typically, the best way to approach this would be to link the tables, use a mapping load or otherwise adjust the schema to fit the data together.

If that isn't feasible for some reason, you could try something like:

Count({< F1 = p(M1) >} F2)

[ZoharB]

Hi, Thanks for your reply. I am not sure I understand, what do you mean by p(M1)? Is this a function, a modifier or what? Thanks for clarifying.

Zohar.

[Or · Accepted solution]

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

p() is the set of possible values

[ZoharB]

Thank you so very much. You helped me solve my problem.