topic Re: Keyword search in QlikView

Keyword search

Wed, 23 Jul 2014 22:09:30 GMT

Hi all, I am new to qlikview( 2 days) and I would appreciate help with the challenge I am currently facing.

I have a below table

ID	Name	city	Hobby
1	Jack	London	I like to play football
2	John	Paris	i like to play basketball
3	Alex	Newyork	i like to play football
4	James	Chicago	i like to play tennis
5	Dave	SF	i like to play tennis

I have a keyword field having the value 'football' and 'tennis'. When user clicks on either of these two values, I need to pull up the particular record. For example, if the user clicks on football, I need to display records 1 and 3. Can someone guide me how to go about this task? I tried searching and couldn't find a similar thread, but kindly point me to one if it exist.

Thank you

Re: Keyword search

ashfaq_haseeb — Thu, 24 Jul 2014 08:24:47 GMT

Hi,

Have a look at the below post.

http://community.qlik.com/docs/DOC-4587

Regards

ASHFAQ

Re: Keyword search

datanibbler — Thu, 24 Jul 2014 08:26:49 GMT

Hi Ravichandran,

usually, as long as the tables are linked, you would be able to make selections and the corresp. records would appear highlighted.

In this case, however, the keyword you want to look for is "hidden" in the text in the >Hobby< field. There are several possibilities, but I think the easiest would be to isolate that keyword (the name of a sport) and to make another field of that - that way, you will again be able to select it easily.

I guess there need not necessarily be exactly four words ("I like to play") in front of the sports_name? If not, then you will need to use a combination of different string functions to isolate that.

HTH

Best regards,

DataNibbler

Re: Keyword search

Thu, 24 Jul 2014 08:45:24 GMT

Hi,

Plz find attached QVW.

just load the data as it is.

create one variable vKeyWord=if(GetSelectedCount(KeyWord)=0,' ',GetFieldSelections(KeyWord))

then make a straight table

take name, id, city as dimension

and

=if(SubStringCount(Hobby,vKeyWord)<>0,Hobby) as expression

and supress null values

Output will be like this.

Regards,

Vivek

Re: Keyword search

Thu, 24 Jul 2014 14:45:06 GMT

Thank you Vivek. Works like a charm