Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(match(title,'Physician'),Name)
Like this create master items for your titles
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.
if(match(title,'Physician'),Name)
Like this create master items for your titles
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
Thanks! It worked. I'm also going to try the other suggestions to help me learn.