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

Compatibility Map - Set Analysis

I want to create a Dimension with set analysis to accomplish a "Compatibility map" using the Tree map visualization.

Once a "TASKNUMBER" is selected, I want to see all other TASKNUMBERS that share at least one of the same "ACCESS", "ZONE" and "PREPARATION" attributes.

 

Here is what I have so far.

aggr(ONLY({1<TASKNUMBER=,  (Select all TASKNUMBERS regardless of selections)

ACCESS= p(ACCESS),

//(Select all possible ACCESS Values BASED ON SELECTION)

ZONE= p(ZONE), 

//(Select all possible ZONE Values BASED ON SELECTION)

PREPARATION=P(PREPARATION)>}TASKNUMBER) 

//(Select all possible PREPARATION Values BASED ON SELECTION)

,TASKNUMBER)

Labels (1)
2 Replies
Anil_Babu_Samineni

Perhaps this?

Aggr(Only({<TASKNUMBER = E({<ACCESS = P(ACCESS), ZONE = P(ZONE), PREPARATION = P(PREPARATION)>} TASKNUMBER)>} TASKNUMBER), TASKNUMBER)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Tee_dubs
Contributor III
Contributor III
Author

That doesn't work for me. However I managed it with 3 separate tree maps
with the relevant set analysis within the measure.