Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor II

Search Object Question

I would like to have one search function that will search for the customer name using either field from two tables. This information is from two different databases but the design for each is the same and contained within one document.

Can I create a calculated search so that when I type in a name, it will bring the data up on each sheet so that the end user just has to change sheets to view.

What is the best way to handle this...I am stuck on these searches.

Field Names:



Thanks in advance!

Tags (1)
2 Replies
Valued Contributor

Re: Search Object Question

I don't know if there's a specification or formula guidelines to create specific search querys, and the only way I can think of doing this is to change the two fields names to a single name so that they'll be the same field for QlikView. That way when you search and select a name in that field it will affect all the document sheets and info. Although this way the field will become a key and you'll have to think how it may affect your data model.

However, now that I think of it, you say that the design for both databases is the same, do you mean that the databases tables are similar? If so, why don't you concatenate the tables?

Re: Search Object Question

What you really should do is rename one of the two fields so the both get the same name. That way the tables can be associated and you will only need to search in one field.

If for some reason you don't want to do this you can try using adding Select in Field actions to the OnSelect field triggers of the two fields. You'll need something like this expression as search string for the Customer field: ='(' & concat(distinct chr(34) & CustomerName & chr(34), '|') & ')'.

talk is cheap, supply exceeds demand
Community Browser