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.
