topic Common Field selection in multiple page in QlikView

Common Field selection in multiple page

Fri, 26 Jun 2015 08:26:11 GMT

Hi All,

Need your help to resolve question with regard to field selection.

if i select a particular field say Country= USA in a tab1 (individual page) and go to next tab (different page) also having a country field which is not same as tab 1 lets say its field name is Country1 having similar countries as compared to country field but the count is less

Is it possible if i select in tab1 country= USA and move to next tab does it automatically select USA

Re: Common Field selection in multiple page

Agis-Kalogiannis — Fri, 26 Jun 2015 09:22:19 GMT

Hi Deepak

You can add a trigger to do that:

Document Properties -> Trigger -> Field Event triggers

Select your Country field and click on OnSelect button

Add an action:

Selection, Select in field,

and for Field, select Country1, and for Search String type: =only(Country)

I hope this helps

Agis

ALK

Re: Common Field selection in multiple page

Fri, 26 Jun 2015 09:40:24 GMT

Hi Agis,

thanks for your quick suggestion, however i tried the same but unfortunately its not working.

Please suggest me some other alternative

Regards

Re: Common Field selection in multiple page

oknotsen — Fri, 26 Jun 2015 09:52:14 GMT

You can also add a trigger on entering a sheet (Sheet properties, Trigger, OnActivateSheet). Put a trigger there that does the same thing Agis described.

Re: Common Field selection in multiple page

Agis-Kalogiannis — Fri, 26 Jun 2015 12:06:07 GMT

I've tested it locally and it's working.

Make sure that you are using exactly the same field names as they are case sensitive.

Also, the only() function will work when you select ONLY ONE country.

Can you please tell me the reason you want both these two fields selected?

Are they associated already? Do they refer to a different thing?

Re: Common Field selection in multiple page

Fri, 26 Jun 2015 12:37:11 GMT

these two fields are non associated with each other but few countries are common in both hence both are diffrent field. the requirement here is if i select any country in one tab the same country should be filter in other tab.

can you please do the changes in my attached qv file and send it back.

Many thanks for your help

Re: Common Field selection in multiple page

Agis-Kalogiannis — Fri, 26 Jun 2015 13:20:32 GMT

Hi Deepak

Is this what you need?

Triggers do not care if the fields are associated or not.

I hope this helps

Agis

ALK

Re: Common Field selection in multiple page

Fri, 26 Jun 2015 15:34:23 GMT

Many Thanks Agis, it works! since i missed to provide action on sheet properties, one more question please

Does it work in reverse way? i mean it works if i go from tab1 to tab2 thats fine, is it possible if i select from tab2 to tab1

thx,

Re: Common Field selection in multiple page

Agis-Kalogiannis — Fri, 26 Jun 2015 16:17:46 GMT

Of course.

You need to do the same and apply the trigger on the other field as well.

Here it is 🙂

Re: Common Field selection in multiple page

Fri, 26 Jun 2015 17:39:53 GMT

Superb! Great help Agis

Much appriciated

Thx