topic Re: Trigger is not working when i link 2 tables in QlikView

Trigger is not working when i link 2 tables

Fri, 21 Apr 2017 07:43:40 GMT

Hi,

I am facing issues with trigger which is not functioning as per my requirement.

I have below 2 tables and linked with "Name" and applied trigger on "Product Region".

When is select "Product Region" trigger is working, but when i deselect the same the trigger is not working.

Table1:

LOAD * Inline

[

Name, Product, Region

Rob, Mobile, AMS

Michale, Non-Mobile, APJ

Jim, Non-Mobile, EMEA

];

Table2:

load * Inline

[

Name, Product Type, Prod Region

Rob, Mobile, AMS

Michale, Non-Mobile, APJ

Jim,Mobile, EMEA

Rob, Non-Mobile, WW

] ;

I have to link the above 2 tables with "Name" and expecting trigger to be work. Please find the attached qvw.

Can anyone help me on this.

Re: Trigger is not working when i link 2 tables

kaushiknsolanki — Fri, 21 Apr 2017 07:48:31 GMT

Hi,

You need to also define trigger for the onChange event.

Have a look at the application. When you deselect the Product Region, it will deselect the Region field.

Regards,

Kaushik Solanki

Re: Trigger is not working when i link 2 tables

Fri, 21 Apr 2017 08:05:11 GMT

As Kaushik said,

define the trigger on On change > action clear field(field name )

Re: Trigger is not working when i link 2 tables

Fri, 21 Apr 2017 08:25:22 GMT

Hi Solanki,

Sorry, I haven't explained my issue correctly. Please find the attachment.

I have 2 triggers here. When is selects 'EMEA' in Prod_region its working but upon that selection if i select "non-mobile" in "product type" it's clearing the selection in "region" filed.

My desired output is

I selects "EMEA" in Prod_Region and then i selects "Non-Mobile" in "Product_Type"

it should select "EMEA" in "Region" and "Non-Mobile" in Proudct(Table1).

It seems tricky, can you please help me on this.

Re: Trigger is not working when i link 2 tables

Kushal_Chawda — Fri, 21 Apr 2017 10:16:36 GMT

see the attached