Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color user who are not in a specified group

Hi,

I want to show all user who belong to a specifed domain, but who are not members of specifed group(s). Data model is like this:

UserLogin
UserDomain
UserGroup

So data would look like this:

John, @john.com, Users
John, @john.com, Admins
John, @john.com, Teachers
Anna, @anna.net, Users
Travis, @travis.org, Users
Travis, @travis.org, Admins

So, I've created a pivot table dimensions UserLogin-UserGroup and I would like to color all UserLogins which are not part of a hard-coded group(s). Or, even better, which are not part of one hard coded group or another hard coded group. Or, even much better 🙂 which are not part of any of the groups selected in the "data-island" field which actually holds all "Group" values.

Thnx 🙂

0 Replies