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
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
$(eColorPicker(60)) // for 60 days average
The world is your oyster!