Qlik Community

Qlik Sense App Development

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

srobertson
New Contributor

How can I filter by only items that match multiple selected dimensions (same field)?

I am working on an app that would allow the user to search capacity based on skillsets.  So my data includes lists of members and their respective skillsets, here is a rough sample of what it would look like:

Member1  |   Skillset 1

Member1  |   Skillset 2

Member1  |   Skillset 3

Member1  |   Skillset 4

Member2  |   Skillset 1

Member2  |   Skillset 4

I am trying to allow the app users to search for "% matches" of skillsets, so if they selected Skillsets 1, 2, and 4 the table would display Member1 as 100% match and member 2 as 66% match.

Any help on how to do this would be greatly appreciated, I have tried what feels like 20 different approachs but have been getting odd/misleading results or errors.

1 Solution

Accepted Solutions

Re: How can I filter by only items that match multiple selected dimensions (same field)?

May be this

=Count(DISTINCT Skill)/GetSelectedCount(Skill)


Capture.PNG



3 Replies

Re: How can I filter by only items that match multiple selected dimensions (same field)?

May be this

=Count(DISTINCT Skill)/GetSelectedCount(Skill)


Capture.PNG



Re: How can I filter by only items that match multiple selected dimensions (same field)?

Or this if you would want to see 100% when nothing is selected.

=Count(DISTINCT Skill)/If(GetSelectedCount(Skill) = 0, Count(DISTINCT Skill), GetSelectedCount(Skill))

Also attaching Qlik Sense sample

Capture.PNG

srobertson
New Contributor

Re: How can I filter by only items that match multiple selected dimensions (same field)?

This worked perfectly!! Thanks!  I was getting lost down the "aggregates inside aggregates" wormhole and lost sight of this type of approach.

Thanks again

Community Browser