Complex Search

shyamcharan — Wed, 19 Nov 2014 01:07:14 GMT

HI Guys,

I have a bit complex search requirement.

I would have a synonym table with they Kewywods and Synonymns.

I would provide a Input box for the user to enter the words he would like to search the records on.

The User Input need to be used to get the list of synonym's and based on the different synonym's the records/list of values need to be searched.

For example:

KeyWord Synonym

dog dog

do pooch

dog hound

dog mutt

dog Puppy

Fix Fix

Fix Repair

BW BAYSWATER

Condenser Condenser

and then:

if the user searches for dog, you search for dog|pooch|hound|mutt|puppy
if the user searches for pooch, you search for dog|pooch|hound|mutt|puppy
if the user searches for hound, you search for dog|pooch|hound|mutt|puppy
if the user searches for mutt, you search for dog|pooch|hound|mutt|puppy
if the user searches for puppy, you search for dog|pooch|hound|mutt|puppy
If the user enters “Fix BW Condenser” -> search on "{Fix|Repair} {BW|Bayswater} Condenser"

I am just wondering how to implement that. I guess the solution that we arrived so far would only work when the KeyWord matches only one Synonym and we use this to search against the Other fields.

But here I would require the user input to pick multiple synonym's and search again as multiple words but not as one string.

The same has been discussed below:

Synonym based List box | Qlik Community

Please suggest on this.

Regards,

Shyam.

topic Complex Search in QlikView

Complex Search