Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Rohan_W
Contributor II
Contributor II

Prompt based calculation in load script to display result in dashboard

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.

 

Labels (2)
1 Solution

Accepted Solutions
Mario_De_Felipe
Luminary
Luminary

1 Reply
Mario_De_Felipe
Luminary
Luminary

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...