topic Re: selecting a field in QlikView

selecting a field

Wed, 25 Nov 2020 16:16:04 GMT

hi ,

i have 2 list boxes.

in one list box with LED style i have two values named as

1. Blue

2. Black

and in another list box and i have the values as

1. IND

2. AFR

3. COC

4. HYD

IND and AFR are from Blue company and COC and HYD from Black

so when i click on IND as it is related to blue , the first list box whiich i ahve blue also should get hightlighted. when i click on HYD , black has to hightlight.

please help.

Re: selecting a field

adamdavi3s — Thu, 08 Dec 2016 13:20:51 GMT

If you want to actually select the item in the other listbox then you can use a field trigger, i will do an example

Re: selecting a field

stabben23 — Thu, 08 Dec 2016 13:24:54 GMT

Hi,

It's all about datamodeling, these 2 tables must be Connected to each other With a keyfield.

How doesYour datamodel looks like?

Re: selecting a field

adamdavi3s — Thu, 08 Dec 2016 13:25:24 GMT

Look at settings> document properties > triggers > field event triggers

This will only work when one val is selected, not multiple.

Re: selecting a field

robert_mika — Thu, 08 Dec 2016 13:31:01 GMT

Is there any association between those two fields?

How does your data model look like?

If you are saying that:

IND and AFR are from Blue company and COC and HYD from Black

How do you know that?

Another way would be to use Mapping load in script level to associate both of those fields:

Don't join - use Applymap instead

Re: selecting a field

adamdavi3s — Thu, 08 Dec 2016 13:54:16 GMT

^ these are both valid, did I take 'highlight' too literally?

Even if the two are linked, selecting one won't select (and therefore highlight) the other.

I started with the assumption that the two were already related / linked and the selection was key

Re: selecting a field

MarcoWedel — Sat, 10 Dec 2016 01:21:48 GMT

Hi,

maybe another solution could be:

LOAD * Inline [
Company, Code
Blue, AFR
Blue, IND
Black, COC
Black, HYD
];

hope this helps

regards

Marco