Hi, I'm very new to Qlik and I'm just trying out a little project.

[#1]

Hi, I'm very new to Qlik and I'm just trying out a little project.  I have a list of individuals in one table. In another table I have the same list of providers in one field with their titles in the other. I created an association between the two tables based on the names field.  I would like to create a master item of only those names that have a certain title so I can use that group of individuals in varies sheets without having to select them each time. So, if the person's title = "Physician", I could just pull in those individuals and each person would appear.

What is the best way to go about that?

Thanks

[rittermd]

If you will only want that type of record then I would just put a where clause in your script.

If it is possible that you would want to see other types in your app then pull them all in and just create a filter for that field.   Then the user can pick whatever kind of records they want to see.

[lakshmikandh · Accepted solution]

if(match(title,'Physician'),Name)

Like this create master items for your titles

[eightieschild]

Hi Diane

If you want to continue using other individuals in other sheets, you may want to use set analysis to only show people with the title 'Physician' in a given visualisation. A tool I have found useful to get started in this is here:

Set Analysis Wizard for QlikView | qlikblog.at

Otherwise, exclude others by adding a WHERE clause to your load script statement.

HTH

Chris

[#5]

Thanks! It worked. I'm also going to try the other suggestions to help me learn.