Assign Variable value during Sheet Load

[chandrasjr]

Hi All,

I have created variable and assigned it to default value say A. On "Sheet1" it needs to have value as A. But on "Sheet2" it should be changed to B.

Currently I am able to change variable value using "Sheet Navigation + Action"  extension. On

• On Sheet1, it shows A. (default value set in variable editor)
• On Sheet 2 when we navigate from Sheet1 to Sheet2 using "Sheet Navigation + Action" button, I can change the variable value to B

But the problem I am having is if I open the Sheet2 directly, the variable has A as value instead of expected value B.

Could you please tell me how to dynamically set variable value based on Sheet we are in. Can this be achieved using out-of-box Qlik functionality or is there any extension that can be used to achieve this.

Regards,

Chandru

[QlikyBobby]

Just bumping this up again.  I am having the same issue.  Is there any method, work-around, or extension to set a variable's value when opening a sheet?

[ajaykakkar93]

Hi,

yes you can do that using a custom extension that has to be developed that will work as qlik view Trigger. you can search 

Link:

https://developer.qlik.com/garden/5b5d47b90f5758001d378640

[QlikyBobby]

Thanks Ajay, I think this will do the trick.

[ajaykakkar93]

Mark it as correct if it works for you.

[QlikyBobby]

Sorry, not sure I can. I did not start the message thread.

[ajaykakkar93]

ya no problem. your issue is solved that is the main point.

[furkanpek]

This extension also solved my problem too. I assigned a value to a variable with that.

[ajaykakkar93]

You can do a bunch of actions..