Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator
Creator

Create a trigger of variable or rocket scince :)

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.

4 Replies
ariel_klien
Specialist
Specialist

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.

BR

Ariel

sona_sa
Creator
Creator

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.

jagan
MVP & Luminary
MVP & Luminary

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.

rwunderlich
MVP & Luminary
MVP & Luminary

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

-Rob

http://masterssummit.com

http://robwunderlich.com