topic Selecting dimension value should navigate to other sheet in QlikView

Selecting dimension value should navigate to other sheet

Wed, 09 Nov 2016 09:26:08 GMT

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

Anonymous — Wed, 09 Nov 2016 09:59:52 GMT

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 — Wed, 09 Nov 2016 10:16:03 GMT

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...