topic Re: Synonym based List box in QlikView

Synonym based List box

shyamcharan — Tue, 18 Nov 2014 11:34:04 GMT

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.

Re: Synonym based List box

agomes1971 — Tue, 18 Nov 2014 11:45:43 GMT

Hi,

really the problem is here:

=IF(WildMatch('*Synonymn*',[Functional Location])=1,'Good')

Synonymn this is supposed to be a variable?

Carefully watch to what you're doing you'll get there...

André Gomes

Re: Synonym based List box

mato32188 — Tue, 18 Nov 2014 11:46:51 GMT

Hi Shyam,

try attached file.

Re: Synonym based List box

tresB — Tue, 18 Nov 2014 11:49:02 GMT

May be like attached sample. Select in the KeyWord/Synonymn field and notice the listbox possible values.

Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 12:06:12 GMT

Hi Andre,

Sorry, Yes I was not sure on that.

I appreciate any help on that.

It is a column from the Synonym table.

Thanks heaps.

REgards,

Shyam

Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 12:08:58 GMT

Hi MArtin,

Creating a relationship does not work in my case. I would have many fields that would need to be searched for based on synonym's.

Regards,

Shyam

Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 12:11:01 GMT

Hi tresco,

I guess we are close but the user would not be selecting anything but just enter 'BW' and I want the list box to show only values that match the synonym words.

Thanks heaps.

Shyam

Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 12:13:12 GMT

Thanks Guys for the quick turn around.

But in my case I would not be creating a relationship to the Synonym table as I would have many fields that would be searched on.

Secondly, The list box would be displaying only the matching values and not all.

I appreciate any help on this.

Thanks heaps in advance.

Regards,

Shyam

Re: Re: Synonym based List box

tresB — Tue, 18 Nov 2014 12:26:43 GMT

This?

Re: Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 12:38:14 GMT

That was awesome piece work indeed.

I guess that just works out for me.

I would get this demonstrated to my user and see how it goes.

Thanks heaps Tresesco

Best Regards,

Shyam

Re: Re: Synonym based List box

shyamcharan — Tue, 18 Nov 2014 22:59:49 GMT

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.

Re: Re: Re: Synonym based List box

JonnyPoole — Wed, 19 Nov 2014 01:32:09 GMT

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

Re: Re: Re: Synonym based List box

shyamcharan — Wed, 19 Nov 2014 01:39:21 GMT

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.

Re: Re: Re: Synonym based List box

JonnyPoole — Wed, 19 Nov 2014 01:47:46 GMT

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

Re: Re: Re: Synonym based List box

shyamcharan — Wed, 19 Nov 2014 01:54:22 GMT

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.

Re: Synonym based List box

JonnyPoole — Wed, 19 Nov 2014 02:02:36 GMT

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 ?

Re: Synonym based List box

rwunderlich — Wed, 19 Nov 2014 02:18:22 GMT

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

Re: Synonym based List box

shyamcharan — Wed, 19 Nov 2014 02:40:03 GMT

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

Re: Synonym based List box

shyamcharan — Wed, 19 Nov 2014 02:48:34 GMT

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

Re: Synonym based List box

JonnyPoole — Wed, 19 Nov 2014 03:26:58 GMT

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