Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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

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

1 Solution

Accepted Solutions
lakshmikandh
Not applicable

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

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

Like this create master items for your titles

4 Replies
rittermd
Not applicable

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

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
Not applicable

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

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

Like this create master items for your titles

eightieschild
Not applicable

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

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

Not applicable

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

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