Solved: Use Exists function in set expression - Qlik Community

ZoharB · ‎2023-08-13

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 · ‎2023-08-13

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)

Or · ‎2023-08-13

p() is the set of possible values

Or · ‎2023-08-13

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 · ‎2023-08-13

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 · ‎2023-08-13

p() is the set of possible values

ZoharB · ‎2023-08-13

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

Use Exists function in set expression