Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

Qlik Sense - Set analysis without linked tables

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Qlik Sense - Set analysis without linked tables

Hi everyone,

Looks like I was not evaluating the expression proppeprly:

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

Thanks.

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Qlik Sense - Set analysis without linked tables

Hi everyone,

Looks like I was not evaluating the expression proppeprly:

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

Thanks.

View solution in original post