Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Valued Contributor II

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

View solution in original post

4 Replies
rittermd
Honored Contributor

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
Valued Contributor II

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

View solution in original post

eightieschild
New Contributor III

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.