topic Re: Matching the Exact name.. in QlikView

Matching the Exact name..

Anonymous — Tue, 07 Jun 2016 07:28:43 GMT

I have two tables as follows,

Table1 :

Table1.name Table1.mom

sachin 1

dravid 2

kohli 1

Table2 :

Table2.name Table2.nickname

dravid wall

kohli virat

sachin god

Here, consider i displayed all Table1.name field in a list box object. (listbox-1)

and similarly displayed all Table2.name field in another list box object. (listbox-2)

What i want is,

when i select any one name fromTable1.name from listbox-1, it should search for the same matching name in Table2.name and should select that reg exact match in listbox-2 also.

Constraint:

i. Without creating a unique key for each row( without associating two tables).

I know its simple, i tried, but somewhere i m missing some logic.!

Thanks.

Re: Matching the Exact name..

tresB — Tue, 07 Jun 2016 07:41:15 GMT

Try using trigger like in attached qvw.

Re: Matching the Exact name..

migueldelval — Tue, 07 Jun 2016 08:19:44 GMT

Hi pandurangan,

Could you check this example?

Regards

Miguel del Valle !

Re: Matching the Exact name..

Anonymous — Tue, 07 Jun 2016 09:37:33 GMT

IS there any other way, other than using triggers..

Like can we do it in an expression.??

Re: Matching the Exact name..

tresB — Tue, 07 Jun 2016 09:47:24 GMT

You can use set analysis like:

=Only({<Name2=p(Name1)>} nickname)

If you select any value Name1 the text box with above expression would give you similar output from Name2's nickname.

Re: Matching the Exact name..

Anonymous — Tue, 07 Jun 2016 11:39:46 GMT

thanks