Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use of SET ANALYSIS

Dear all,

I tried to apply the use of the set Analysis with "CLUSTERS" of data.

In specific, I attempted to make the union  of two Clusters (1+2) and the difference (1-2)

I enclose an easy example that do not work propery

More in details, we have 4 items in the first cluster (Giacomo, Gianni, Giovanni, Leopardi) and 3 items in the second (Giacomo, Leopardi, Leopoldo)

Only two of them are in common. The first cluster has 2 elements not included in the second and the second cluster has 1 element not included in the first

The attemps is to create:

1) The INTERSECTION of the 2 clusters, using the operator "*". The example works and the result is 2 items (Giacomo, Leopardi).

    The formula I used is:

     sum( {<Nome=>*<FileDUE.Nome=>} FileDUE.StipendioDUE + StipendioUNO)

2)  The UNION of the 2 clusters, using the operator "+". The result should be a list of 5 items (Giacomo, Gianni, Giovanni, Leopardi,  Leopoldo), but it DOES NOT WORK

    The formula I used is:

    

     sum( {<Nome=>+<FileDUE.Nome=>} FileDUE.StipendioDUE) + sum( {<Nome=>+<FileDUE.Nome=>} StipendioUNO)

3)  The DIFFERENCE of the 2 clusters, using the operator "-" (Cluster 1 - Cluster 2). The result should be a list of  all the elements included in the first cluster that are not in common: 2 items (Gianni & Giovanni).. , but it DOES NOT WORK

    The formula I used is:

    

     sum({<Nome= {}> - <FileDUE.Nome = {}>} StipendioUNO)

Could someone help me to sort out this issue?

Thanks

Alberto

1 Reply
whiteline
Master II
Master II

Hi.

I guess, everything's working as it supposed to be.

You have different tables and different dimensions, while the described behaviour suspects a shared dimension.