Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Tee_dubs
New Contributor II

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

Re: Compatibility Map - Set Analysis

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Tee_dubs
New Contributor II

Re: Compatibility Map - Set Analysis

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