#40 🎢 Bump Chart in Qlik Sense

Wanna measure rank over time ? 🥇 My mate Patrick Tehubijuluw introduce you to Bump Chart at DataOnTheRocks🤟

After years working with Qlik, the "wow effect" is my favourite moment in a project with end users

You want to blow your audience away? 😮

Bump Chart is made for you !

Read why to use it and how at dataonthe.rocks/bump-charts/

Pretty cool and easy to do right ?

I spiced it up a little bit in this post to have my lines colored if selected with conditional color 🧙‍♂️

⁉How to ⁉

After following Patrick's step by step

Change your measure to unable the dimension used for lines; In my example it's Sub-Category

rank( sum( {$<[Sub-Category]=>}Sales), 4 ) * (-1)

Then put this in Colors by expression :

if(isnull([Sub-Category]) or GetSelectedCount([Sub-Category])=0,rgb(200,200,200),rgb(46, 204, 113))