Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
michele_stenico
Partner
Partner

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

View solution in original post