#34 🤴 Context is King - Specific insights in Qlik Sense
Context is King 4 🤴 Tickle user's curiosity with specific insights 🕵️♂️
If you have some free space available, why not adding some facts to draw people attention ?
Context can be pushing insights to help the user to question himself. This is how you can guide him to the next question or another analysis in your app
💡 A great combination of this kind of information is to add button to filter data and move to a specifi sheet for example
In my text box, I'm using FirstSortedValue(), Aggr() and Rank() to display some facts 🧙♂️
What do you think of this texts ? What other information could we put in it?
⁉How To ⁉
👨🎓 Get the first value of a dimension from a measure with :
FirstSortedValue( City,-aggr(Sum(Sales),City))
👨💻 Measure for the first value of a dimension :
sum({$<[Product Name]={'$(=FirstSortedValue( [Product Name],-aggr(Sum(Profit),[Product Name])))'}>}Profit)
🦸♂️ Measure for the first X values of a dimension :
sum(aggr(if(rank(sum(Sales),0,1)<10,Sum(Sales),0),[Customer Name]))
Read more about Context
