Prompt based calculation in load script to display result in dashboard

[Rohan_W]

Dear Team,

I have this requirement wherein user will select\enter particular value in the prompt and that value should get passed on to a macro variable to calculate some value on the load script and dashboard values should be displayed accordingly.

For ex - User will select\enter value (90) in prompt then the value should be passed in the load script to divide the exposure amount (9000)and then the resulting value (100) should be displayed in the dashboard.

Please suggest if this is feasible.

[Mario_De_Felipe · Accepted solution]

You have two ways:

1. You could use a .qvs file to set the variable: https://www.youtube.com/watch?v=GfYGwxhbJUw
2. You could use and input variable object: https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Visualizations/DashboardB...