In my QlikView dashboard I have the below three fields.
1. Employee Name
2. Supervisor Name
3. Manager Name
I would like to build a search facility in my QlikView dashboard which performs a search across these three fields.
For example, when I search for 'John' the system should show all those records where John is either a employee name or supervisor name or manager name?
Just create a new Search Object and select the three fields at selected fields. Then you can search in the three different fields. When you then type "John" in the search box you will get three different lists one for the employee name, one for the supervisor name and one for the manager name.
I tried this option, but I am limited to select only one. But what I want is 'I need all those records where John is either employee name or supervisor name or manager name.
Employee Name Supervisor Name Manager Name Product
aaa bbb ccc 1
ccc aaa eee 2
fff ggg aaa 3
When I seach for 'aaa' I would like to see all three records. How is this possible in QlikView?
It seems that normal functionality in Qlikview doesn't support this until you are down to one of the options.
"If several list boxes are active (SHIFT-click on their headers to make them active),
they are all included in the text search. Pressing ENTER to select the resulting values is
however not possible until there are optional values in only one of the active list
boxes." (Reference guide, p131)
I noticed that you could hold ctr key and select all three, but it is not the most user friendly to do this. Not sure if there are other ways to fix this.
You may draw a ribbon with the mouse around the three boxes, which are to be searched and start typing. So in each of the boxes you will see the search narrowed down, but you have to select finally one.
As from version 10 you have the "Search Object" with similar functionality.
Alternatively you may concatenate in your script the three fields into a separate one and then do the search in it.
