Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting dimension value should navigate to other sheet

Hi,

After selecting one product from a straight table 1 on Sheet 1 user should be navigated to Sheet 2.

After selecting one Customer from a straight table 2 on Sheet 1 user should be navigated to Sheet 3.


IF more than one product or customer is selected this navigation should not happen.


Thanks

Khushboo

2 Replies
Anonymous
Not applicable
Author

Hi, Use Field Event Triggers:

Goto: Settings > Document Properties > Triggers (See Image attached & Sample application) (Or Alt + Ctrl + d)

Within the Field Event Triggers box, on fields Product & Customer, edit the OnSelect trigger.

For Customer field:

Add> Layout> activate Sheet

Sheet ID box =if(GetSelectedCount(Customer)=1,'SH03',Null())

For Product field:

Add> Layout> activate Sheet

Sheet ID box =if(GetSelectedCount(Product)=1,'SH02',Null())

Hopefully that helps...

Deez

Anonymous
Not applicable
Author

Hi,

Just in case you have more than 3 sheets in your app and do not want the navigation active on other sheets when a customer or Product is selected.

See sample app with a new variable and updates to the expressions used.

*** The first sheet now has sheet triggers OnActivateSheet and OnLeaveSheet to set the new variable...