Synonym based List box

[shyamcharan]

Hi Experts,

I have a requirement where I need to show the values in the list box that matches the synonym words.

For example:

I have a table with synonym words.

SYNONYM:

LOAD * INLINE [

    KeyWord, Synonym

    BW, BAYSWATER

    B Water, BAYSWATER

    LD, LIDDELL

    LDL, LIDDELL

];

FL:

LOAD * INLINE [

    Functional_Location

    Bayswater Power Station

    Bayswater Unit 1

    Bayswater Unit 2

    BW-BAYSWATER

    LIDDELL Power Station

    LD_LIDDELL

];

User would enter something like 'BW' in the Input box. This would in return fetch me the Synonym as BAYSWATER from the Synonym table and I would like to use this to search against the original field Functional location and display only related List of values.

Now, I would like to have a list box Functional Location that matches with the word 'Bayswater' as it has in the synonym table. but not all.

I have tried and attached the same but somehow i am unable to get the wildmatch worked.

Any suggestions on this would be really help ful.

Thank heaps.

Regards,

Shyam.

[shyamcharan]

HI Guys,

I have a bit complexity that I came to know lately.

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.

Please suggest on this.

Regards,

Shyam.

[JonnyPoole]

Here is an example that covers all but the last use case.

Small glitch, you need to hit enter after typing in the input box before hitting search words

[shyamcharan]

Thanks for the reply jonathan.

But I guess the attachment is a wrong one. I dont see the objects shown in the screenshot.

Can you please reattach it.

[JonnyPoole]

that was silly of me! I reattached to the previous post

[shyamcharan]

Thanks Jonahtan.

In your example, the synonym's are concatenated to form one word.

But my requirement is to get different synonym's based on the words entered and search based on different synonym's.

In fact the last use case is what I would require to do.

Thanks heaps in advance.

[JonnyPoole]

The concatenation is actually a search string that consists of all the synonyms that are associated to the keyword that itself  is associated to what the user types in.

So if they type in 'pooch', it figures out that 'pooch' is associated to 'dog' and then it looks at ALL the synonyms associated to 'Dog' and searches for ALL of those through the (value1|value2|etc..) syntax...  which includes pooch, dog, mutt etc.....  Although it looks like one long string, Qlik will search/select  for each individual value in the list.

That seemed to match  the samples (except the last one which this doesn't handle)

Is that right ?

[rwunderlich]

Could you handle the requirement by teaching your users to use Associated Search? If you are not familiar with the feature, see section 14.10 "Search" in the Ref Guide.

-Rob

[shyamcharan]

Thanks Jonathan.

Yes, Thats what I want. The search should be done considering all the synonyms as different values but not as one string.

With your example can I get a list box using the synonym's ("Dog"|"Hound"|"Mutt"|"Pooch"|"Puppy")

Again the Dog, Hound, Mutt Pooch and Puppy are different values and these different values need to be searched in a field that might have values with these synonym words.

Thanks heaps

[shyamcharan]

Hi Rob,

I had a look at it and could not figure out the Chevron. Could you please attach an example if possible.

Thanks heaps for the help.

Regards,

Shyam

[JonnyPoole]

That is exactly what I wrote the sample to do ... if you add a list box on the right, you can see that when i type in 'Hound' and hit 'search words' it selects all the synonyms of 'Dog'.

Note that in this sample the synonyms are capitalized words , so to test it make sure you enter a capitalized synonym. Its simple to update if its working as you need. Just let me know