Download Set Analysis Primer

x

Nested Parameterized Variables

Dixit’s last article on how to use parameterized variables in both QlikView and Qlik Sense generated a good bit of buzz.

Many asked questions about nested parameterized variables.

I thought of creating a sequel post to use new features in Qlik Sense April 2020 release to show how to nest parameterized variables using dollar-sign expansion.

Qlik Sense April release has a new chart type: Button

The button can also trigger actions so we can set a variable vDays for each button with value and nest the same variable within the variable that contains the Set expression for the KPI

($(e_AvgOrders_X_Days(vDays)))

We can also use the same variable to display a dynamic title

=vDays & ‘ Days Average’

We can go one step further by creating a background color expression and storing that as a parameterized variable, eColorPicker, using a combination of pick() and match() functions.

pick(match(vDays, $1), $(vSelectedColor))

where, vSelectedColor = rgb(88,24,60)

Now, we can apply parameterized variables to display button background color dynamically using the following expression.

$(eColorPicker(30)) // for 30 days average

or

$(eColorPicker(60)) // for 60 days average

The world is your oyster!

Let Us Help You Take Your Qlik Skills to the Next Level!

If you enjoyed this article, get email updates (it’s free).

* indicates required
About the author