Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

Is there any way to get the Id of previous page?

Hi guys!

Here's my situation :

I have 3 sheets : sheet1, sheet2 and sheet3.

I have 3 kind of dates : date1, date2 and date3.

Sheet1 has date1, sheet2 has date2 and sheet3 has date3.

What I'd like to do is to transfer the selected date value between sheets through sheet triggers.

I've thought the best way to do it is detecting which was the previous page you visited, and change the values of the known fields.

What do you think? Is there any way to detect which was the previous page in triggering sheets? Or is there any better way to do it?

The problem is to solve the possible combinations of user navigation :

From sheet1 to sheet2,

From sheet2 to sheet3,

From sheet3 to sheet1,

.....

Regards, Marcel.

1 Solution

Accepted Solutions
israrkhan
Specialist II
Specialist II

Hi Olmo,

I think you can do it by defining two variables, 1) v_active_sheet_id, and previous_sheet_id,

and can get currentsheetid by using GetActiveSheet function.

when you change the sheet, you can assign vactive_sheet id to previous_sheet_id,by using a tiger.

and the you can check what is the value in previous_sheet_id variable.

Khan

View solution in original post

3 Replies
israrkhan
Specialist II
Specialist II

Hi Olmo,

I think you can do it by defining two variables, 1) v_active_sheet_id, and previous_sheet_id,

and can get currentsheetid by using GetActiveSheet function.

when you change the sheet, you can assign vactive_sheet id to previous_sheet_id,by using a tiger.

and the you can check what is the value in previous_sheet_id variable.

Khan

tresesco
MVP
MVP

Are you using alternate state? If the Date fields are mutually exclusive, can't we take the selection from Date1 to Date2 on sheet change trigger?

marcel_olmo
Partner Ambassador
Partner Ambassador
Author

Thanks Guys I do this :

Var1.png

var2.png

And it works like a charm!

Regards, Marcel.