#68 🎉Welcoming the Emoji Chart in Qlik Sense
🎉Welcoming the Emoji Chart 👨🔧 or how to hijack the Text Object in #Qlik Sense ✔ #dailyqlikchallenge 68 ...
Numbers, bars, lines are outdated!
Take your Dataviz to the next level with Emojis 🤩
It's not April 1st, so I'm not kidding...
Or maybe I am, who knows 😋
I was freely inspired by Frédéric Vissers 's post yesterday, where he replaced the numbers in a table with an Emoji
A good opportunity to hack the text object and talk about Emoji
Easy to do with proper use of Aggr, Concat and Repeat functions 🧙♂️
Get the full details :
How to do it in Qlik Sense ?
Create two Text Object, one for Axis and another for Emojis
First one is :
concat(aggr( concat(Product) ,Product)
,chr(10),-Sales)
Second one :
concat(aggr(
repeat(Emojis,
round(sum(Sales) / $(=Max(aggr(sum(Sales),Product)))*10))
&' '&sum(Sales)&repeat(chr(32),3)
,Product),chr(10),-Sales)
