Qlik Sense - Set analysis without linked tables

[RogerBenjumea]

Hi everyone,

I am trying to develop a Set Analysis with two tables which are not linked in the data model.

I have the data model and a replica of one of the model's table. The main idea of this functionality is to make a selection which does not have any influence to the relational model, but which could be used in the set analysis in order to make comparisons.

I have tried the following:

Sum(${<T1.Field1={'$(=GetFieldSelections(T2.Field1))'}>} T1.Field2)

The Qlik's KPI gets the GetFieldSelections value, but, when evaluating, it does not have any effect.

I am not sure if it has anyhting to do with the fact that, when using the fields as dimensions in a table, I obtaing the following:

T1.Field1:                                         T2.Field1:

1                                                           1

2                                                           1

3                                                           1

1                                                           2

2                                                           2

3                                                           2

[RogerBenjumea · Accepted solution]

Hi everyone,

Looks like I was not evaluating the expression proppeprly:

Sum({<T1.Field1={'$(=T2.Field1)'}>} T1.Field2)

Thanks.