Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
currently I'm making a dashboard based on People and their Skills.
I have a filter like this:
Interface Design - No Experience |
Interface Design - Proficient |
Jboss - Basic Knowledge |
Jboss - Intermediate |
Jboss - Limited Experience |
Jboss - No Experience |
Jboss - Proficient |
Logo Design - Advanced |
Logo Design - Basic Knowledge |
and when I click on the first row (for example) a KPI visualization shows me how much People I have with that Skill and Level of experience.
Now, if I click on another row, I want that KPI visualization to show me how much People I have with both skills combined.
The thing is, its showing me the people I have with 1 of the two skills (minimum) which raises the count of people instead of decreasing it.
I hope I explained it well. If you need anymore info or screenshots pls say so.
KPI is= Count(distinct USER_ID) or Count(${<SKILL_AND_LEVEL={}>} Distinct USERID) .
That filter shows SKILL_AND_LEVEL field.
thank you all.
There is a way to change the filter from an OR to AND in QlikView. But I don't know if there is a way to do that in Qlik Sense. I would check Qlik Branch to see if there are any extensions that might do that.