A business analyst created a visualization that has a color indicator when an order is below a certain fixed profit threshold. This visualization now…

The most effective and efficient solution is to use a variable controlled by a slider. Variables in Qlik Sense act as dynamic placeholders whose values can be changed by users in real-time without requiring a data reload. By linking a variable to a slider object, users can intuitively adjust the threshold value. The visualization's color expression can then reference this variable (e.g., If(Sum(Profit) < $(vProfitThreshold), 'red', 'green')). This approach provides each user with a personalized, interactive experience, which is ideal for "what-if" analysis and aligns perfectly with the requirements.

A. A filter pane operates on existing field values within the data model. This would require pre-defining a list of thresholds, preventing users from inputting their own specific values.

B. This is highly inefficient as the app's data only changes daily. Frequent reloads are unnecessary, and a shared spreadsheet would not allow for individual user-defined thresholds.

D. The Bucket function is a data load script function that creates static, pre-defined ranges. It does not allow for dynamic adjustment by the user within the published application.

---

1. Qlik Sense for Windows Help, "Using variables in expressions": This official documentation explains that variables can be used to support "what-if analysis." It explicitly states, "You can use specific objects to change the value of a variable dynamically in an app," which directly supports the use of a slider or input box to control a variable's value post-reload. (Accessed via Qlik Sense for Windows Help, section: Creating visualizations > Using expressions > Using variables in expressions).

2. Qlik Sense for Windows Help, "Dashboard bundle": The documentation for the Dashboard bundle describes the "Variable input" control, which can be rendered as a slider. It states this object "lets you set the value of a variable," confirming it is the standard tool for implementing the functionality described in the correct answer. (Accessed via Qlik Sense for Windows Help, section: Creating visualizations > Bundles > Dashboard bundle).

3. Qlik Sense for Windows Help, "Bucket - script and chart function": This page details that the Bucket function is used during the data load script to classify numeric values into discrete text-based ranges. This confirms it is a static transformation and cannot be altered by the end-user in the analysis view, making option D incorrect. (Accessed via Qlik Sense for Windows Help, section: Scripting > Script syntax and chart functions > Logical functions > Bucket).