Prompt based calculation in load script to display result in dashboard

Rohan_W — Fri, 15 Nov 2024 21:24:03 GMT

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.

Re: Prompt based calculation in load script to display result in dashboard

Mario_De_Felipe — Tue, 12 Sep 2023 06:30:47 GMT

You have two ways:

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

topic Re: Prompt based calculation in load script to display result in dashboard in Reporting Service & Alerting

Prompt based calculation in load script to display result in dashboard

Re: Prompt based calculation in load script to display result in dashboard