Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chandrasjr
Contributor II
Contributor II

Assign Variable value during Sheet Load

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

8 Replies
QlikyBobby
Contributor II
Contributor II

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?

I wanna Qlik fast
ajaykakkar93
Specialist III
Specialist III

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

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

QlikyBobby
Contributor II
Contributor II

Thanks Ajay, I think this will do the trick.

I wanna Qlik fast
ajaykakkar93
Specialist III
Specialist III

Mark it as correct if it works for you.

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

QlikyBobby
Contributor II
Contributor II

Sorry, not sure I can. I did not start the message thread.
I wanna Qlik fast
ajaykakkar93
Specialist III
Specialist III

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

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

furkanpek
Contributor
Contributor

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

ajaykakkar93
Specialist III
Specialist III

You can do a bunch of actions..

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting