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!
