topic Re: Select linked value from another field in QlikView

Select linked value from another field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dears

Im using a input box to select multiple item no. in teh app.

I set a variabel vSearchItem and set variabel trigger action to trim the Item no.

='(' & Replace(Replace(Replace(Trim('$(vSearchItem)'), ' ', '|'),' ', '|'), chr(10), '|') & ')'

This works nicely

Now i would go one step further and selecte values from another field. In this case i would like to get selected the %Subassambly instead of the %Item field values.

dim_tabel is

%Item, %Subassembly

Item1, Sub1

Item2, Sub1

Item3, Sub2

Item4, Sub3

the logic should be, if somebody will paste Item1 and Item3 in the input box, the selection should be Sub1 and Sub2.

thansk for help

Rgs

Re: Select linked value from another field

sunny_talwar — Fri, 08 Jul 2016 10:06:51 GMT

Would you be able to share a sample where you might be playing around with this?

Re: Select linked value from another field

Anonymous — Fri, 08 Jul 2016 11:00:07 GMT

Sure

Value for copy past into inputbox

Item1

Item3

Should select

Sub1

Sub2

from field %SubItem

Re: Select linked value from another field

sunny_talwar — Fri, 08 Jul 2016 11:07:41 GMT

Check the attached

Re: Select linked value from another field

settu_periasamy — Fri, 08 Jul 2016 11:23:24 GMT

Hi,

i added 2 more actions in the variable event trigger. see attached

Re: Select linked value from another field

Anonymous — Fri, 08 Jul 2016 11:37:29 GMT

it works by your solution

Even hard to understand for me what you have done on that button

The select possible event trigger is easier for me, to handle the dataimport

Many thansk for your support

Re: Select linked value from another field

Anonymous — Fri, 08 Jul 2016 11:40:31 GMT

Cool

Jep, thats exactly the solution which im looking for, can also easely use multiple selctions of fields, so even better

Many tanks

Re: Select linked value from another field

sunny_talwar — Fri, 08 Jul 2016 12:20:21 GMT

The reason I provided the complicated expression was because that you only wanted to trigger on %SubItem and leave %Item as is (without selecting it). If both needs to be selected, then what Sethu proposed is def. a better solution.

If you don't mind me asking, can I ask you the reason for selecting both %Item and %SubItem? I am just trying to understand the benefit of doing this since indirectly you have already filtered out on to only those %SubItems which are possible based on your selection in %Item.

Best,

Sunny

Re: Select linked value from another field

Anonymous — Fri, 08 Jul 2016 12:55:59 GMT

Your toughts about my needs are completely correct, just subitem should be selected and not the item

I have just added clear field as action to get the result

Cheers Rob

Re: Select linked value from another field

sunny_talwar — Fri, 08 Jul 2016 12:59:44 GMT

For me adding 1 single trigger might be more efficient, easy to maintain and less confusing for the users. But that is just my thought, whatever works better for you is the best

Thanks for sharing more information.

Best,

Sunny

Re: Select linked value from another field

Anonymous — Fri, 08 Jul 2016 13:14:51 GMT

Since my knowledge is still very basic, its better to add functions which i understand, especially if i need to dig into, in some couples of weeks. Just like to keep the things simple for now... Im pretty sure that your solution might be the better one, as everything is done in one step... I have stored your sample and will review it for sure, once i have gained some more expericance

Thanks for all the feedback on this topic

Cheers Rob