#48 📖 Telling a story in Qlik Sense

📖 Telling a story or add dynamical Context in Qlik ?

Challenge succeed with the new Animator in Sense Sept 20


You know that I love Context and ways to add it in our apps

I also recently played with the Animator Object which allow to loop through dimension values

So I was wondering how to display measures dynamically 🤔

It's a bit tricky but working nicely actually. Could be used to really tell a story by displaying insights one after each


I had to store Expressions in variables, then load a table in the script, and call this variable in the front end 🧙‍♂️

Download QVF
Sheet Animated Sheet Title

⁉ How To ⁉

Create variables like :

KPI_3 : =num(Sum(Sales),'#,##0')

List them and add an id and Label :

KPI:
load * Inline [
id_KPI, Expr, Label
1,KPI_1, 👨‍💼 # of customers is
2,KPI_2, 🏙 First city for Sales amount is
3,KPI_3, 💰 Total amount of Sales is
4,KPI_4, 🤑 Total profit is
5,KPI_5, 📈 Profit rate is
];

The sheet Title expression is :

Label&' '& '$($(=Expr))'

That lot of 💲 isn't it? 😉

To display them in the text object, the syntax is a bit different 🤯:
only({$<id_KPI={$(=id_KPI-1)}>}Label)
&' '&
'$(KPI_$(=id_KPI-1))'

Cheers 😉