Qlik Sense - Set analysis without linked tables

RogerBenjumea — Sat, 16 Nov 2024 03:55:59 GMT

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

Re: Qlik Sense - Set analysis without linked tables

RogerBenjumea — Wed, 04 Dec 2019 12:22:34 GMT

Hi everyone,

Looks like I was not evaluating the expression proppeprly:

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

Thanks.

topic Re: Qlik Sense - Set analysis without linked tables in App Development

Qlik Sense - Set analysis without linked tables

Re: Qlik Sense - Set analysis without linked tables