Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Trigger is not working when i link 2 tables

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.

!

Tags (1)
4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Trigger is not working when i link 2 tables

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Trigger is not working when i link 2 tables

As Kaushik said,

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

Highlighted
Not applicable

Re: Trigger is not working when i link 2 tables

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.

Highlighted

Re: Trigger is not working when i link 2 tables

see the attached