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: 
michele_stenico
Partner - Contributor III
Partner - Contributor III

Qliksense Button: set target sheet name with a Variable

Hi,

I have an App  (February 2021 version) with many sheets thet show differnt aggregation of same details Data. Data of dettail are showed in one sheet. In every sheet I have inserted a button that allows to navigate to details sheet. I would Like insert a button in the detail sheet to go back to the starter sheet. I have tried to use a Variable that is set in starter sheet, but the solution seems not working.

Do somebody have any suggestions ?

Thanks,

Michele

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

In the button that navigates to the Details sheet, add 2 actions.  In the first action set the variable (vSheetID) to the current "Sheet ID" (Sheet1).  Capture2.PNG

In the second action, activate the Details sheet

Capture3.PNG

On the Details sheet, in the button that navigates to the previous sheet add the "Activate Sheet" action with this formula:  ='$(vSheetID)'

Capture4.PNG

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

In the button that navigates to the Details sheet, add 2 actions.  In the first action set the variable (vSheetID) to the current "Sheet ID" (Sheet1).  Capture2.PNG

In the second action, activate the Details sheet

Capture3.PNG

On the Details sheet, in the button that navigates to the previous sheet add the "Activate Sheet" action with this formula:  ='$(vSheetID)'

Capture4.PNG