Dynamic Selection & Bookmark with hidden field (HidePrefix)

[Amit_B]

Hi,

I have an app with 3 sheets.
The app should open on Sheet A with filter for the current year.
If the user move from Sheet B back to Sheet A, the sheet should filter for the current year and specific value in another field. This field name is hidden (HidePrefix function).

I thought of using a variable (I defined a variable, v_IsSheetB, that gets '1' every time the user move to Sheet B using actions) and actions, but I can't do actions on a hidden field.
I've tried setting a dynamic bookmark with a condition (something like: =[_field]=if(v_IsSheetB=1,'[value]')), but I'm not getting the desired result.
It also doesn't work if I use 2 bookmarks - the first one is the default (year), and the second bookmark (year & field) is set in Apply Bookmark action (in Sheet Properties). The app always opens according to the second bookmark.

I would love for some help and more ideas.
Thanks!

[Lech_Miszkiewicz]

I know it is very poor design by Qlik but what you can do... 

The workaround should be to:

• unhide the field
• apply all actions / test
• hide field again

cheers

[Amit_B]

After I hide the field again the action doesn't work.

please tell me if I do something wrong:

I used the variable I created, and create an action 'Select values matching search criteria".
The field name didn't change there after I hide it again (in other places I needed to add '_' before the name).
The expression is '=if(&(v_IsSheetB)=1,'[value]')' (it's work for unhidden fields).