How to set a variable on a sheet via the URL

pnaik — Wed, 09 Mar 2022 17:03:49 GMT

I have a sheet that has a variable and that variable is used when a call is made "REST API Connector" to load data. This variable differs base on who his logged into my app. The report is the same but data will be different based on the user.

example

"https://qlikcloud.com/single/?appid={someappid}&sheet={somesheetID]&theme=card&opt=ctxmenu&select=clearall&vUserContext(userX)"

where vUserContext is the variable in the sheet and "Userx" is the value for that variable.

So how do i set it via the URL, what is the syntax

Re: How to set a variable on a sheet via the URL

Alexis_Touet — Wed, 30 Mar 2022 06:51:46 GMT

Hi @pnaik

This is not possible to control the variable value through a URL parameter. For your use case, the best solution would be to use section access if you want to have different users see different data.

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

Hope this helps.

Best regards,

Alexis

topic How to set a variable on a sheet via the URL in Integration, Extension & APIs

How to set a variable on a sheet via the URL

Re: How to set a variable on a sheet via the URL