Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi everyone,
Looks like I was not evaluating the expression proppeprly:
Sum({<T1.Field1={'$(=T2.Field1)'}>} T1.Field2)
Thanks.
Hi everyone,
Looks like I was not evaluating the expression proppeprly:
Sum({<T1.Field1={'$(=T2.Field1)'}>} T1.Field2)
Thanks.