Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.