topic Re: set analysis on data island in QlikView

set analysis on data island

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

hi, i have a data island that contains a key field, the same key field exists in another island-named differently (i do not want them to link).

the data in one table has been reduced and the data in the island holds the full data set.

i have a straight table that i want the reduced data value of field A to show against the full data set of the same field value in the island, if that makes sense.

example.

ReducedTable

Dimension,ReducedTotal

NameA, 100

NameB, 50

NameC, 200

FullTable - Data Island

Dimension2, FullTotal

NameA, 1000

NameB, 500

NameC, 20000

at the moment the result of the straight table is..

Dimension ReducedTota FullTotal

NameA 100 21500

NameB 50 21500

NameC 200 21500

this is obviously because there is no link between the tables (which is correct)

The result i want is..

Dimension ReducedTotal FullTotal

NameA 100 1000

NameB 50 500

NameC 200 20000

Can anyone help to achieve this?

i have tried the simple way of

Sum{<Dimension=Dimension2>}FullTotal

any help would be appreciated

example attached

Re: set analysis on data island

Clever_Anjos — Tue, 21 Jun 2016 16:21:31 GMT

Please try

Sum( {<Dimension=P(Dimension2)>} FullTotal)

Re: set analysis on data island

hopkinsc — Tue, 21 Jun 2016 16:23:04 GMT

hi, thanks for the reply, that gives the same output unfortunately. 21500 on each line

Re: set analysis on data island

Clever_Anjos — Tue, 21 Jun 2016 16:24:00 GMT

Checking your app, you need that Dimension2 corresponds to the Dimension1 aggregation of graph? It´s not possible using Set Analysis,

Set Analsys cube expansion is calculated before the aggregation of the graph

you need this

SUM( if ( Dimension = Dimension2, FullTotal ))

Re: set analysis on data island

Clever_Anjos — Tue, 21 Jun 2016 16:24:56 GMT

Further reading A Primer on Set Analysis

Re: set analysis on data island

hopkinsc — Tue, 21 Jun 2016 16:26:19 GMT

thanks very much, perfect

Re: set analysis on data island

Clever_Anjos — Tue, 21 Jun 2016 16:31:36 GMT

Good to read that