Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Freelansir
Contributor II
Contributor II

How to exclude values from a Dimension (master)

I have built a small application for a health clinic which I manage.

I want just one field for our "Practitioners" but I ended up including another table as well for "Staff Issues", which also included a column for who the issue was about.

These issues could include "Practitioners", but also can include "Receptionists".

Clinic

- Practitioners

- Receptionists

For the purposes of this master link, I really just want Practitioners who have appointments, and not our employees (ie. Receptionists).

I'm not very good with Qilk - what would be the best way to do this - can I filter out these values after the fact, or do I need to mess around with how I have mapped the data?

 

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Define the master dimension as

If(Match(Practitioner,'Sarika','Sarita','Shariene') > 0,Null(),Practionioner)

 

View solution in original post

4 Replies
jwjackso
Specialist III
Specialist III

Define the master dimension as

If(Match(Practitioner,'Sarika','Sarita','Shariene') > 0,Null(),Practionioner)

 

Freelansir
Contributor II
Contributor II
Author

So I put the expression in the "Label Dimension" field of the master dimension, but it did NOT remove the users from the list.

Are there other steps I need to follow ?? Is there something I need to do to exclude NULL values from the selection list?

Thanks!

2021-06-12_10-56-14.png

jwjackso
Specialist III
Specialist III

Put the expression in the field

Untitled.png

Freelansir
Contributor II
Contributor II
Author

OMG - Thanks so much, that worked perfectly.

Thanks a ton for the patience. Of course that's where you should put the expression 😃

I'll get the hang of Qlik eventually. Thanks again.