topic Re: Create a trigger of variable or rocket scince :) in QlikView

Create a trigger of variable or rocket scince :)

sona_sa — Wed, 10 Jul 2013 15:21:42 GMT

Hi,

I have to sheet. In one sheet I have one straight table with one dimension (Customer) and 4 expression. Now i want to click on one customer A and on the Click of A, the trigger should to fire and go to sheet 2 and show the data for one A. but In both sheet Cutomer are coming from different - different tables.

Please help me ASAP.

Thanks.

Re: Create a trigger of variable or rocket scince :)

ariel_klien — Wed, 10 Jul 2013 15:29:08 GMT

Hi,

Try to make a key between the 2 different tables using the same field in both of the tables. (like CustomerID)

then when you select 1 customer in one sheet it will filter this customer in all sheets.

Ariel

Re: Create a trigger of variable or rocket scince :)

sona_sa — Wed, 10 Jul 2013 15:48:32 GMT

Done, But I am clicking on one of the expression and then the sheet 16 should be activated and that particulr field value.

Thanks for reply.

Re: Create a trigger of variable or rocket scince :)

jagan — Wed, 10 Jul 2013 15:53:15 GMT

Hi,

Try like this

Document Properties -> Triggers -> Field Event Triggers -> Select Dimension -> On Select -> Add Action -> Select Layout -> Activate Sheet and give sheet ID.

Now whenever you select value in the field the given sheet is opened.

Hope this helps you.

Regards,

Jagan.

Re: Create a trigger of variable or rocket scince :)

rwunderlich — Thu, 11 Jul 2013 00:00:29 GMT

See attached using a combination of OnSelct triggers and conditional show.

-Rob

http://masterssummit.com

http://robwunderlich.com