Today, when designing a Qlik Sense object with alternative dimensions it is hard to create dynamic behaviour based on which dimension is choosen.
Example 1: Header
I would like to dynamicly set the object header based on which dimension is choosen in my object.
Header: ='Sum of sales per' & #My active dimension#
Example 2:
I also would like to create an an aggregated average calculation as a reference line using the active dimension the dimension used in my aggr.
Ref Line: =avg(aggr(Sum(Sales), #My active dimension# )
I believe this could easily be accomplished by letting the function GetObjectField() become available in all parts of an Qlik Sense chart object, not only in the measure and dimension expressions.
My suggestion is that GetObjectField() becomes available in these locations as well:
- Title
- Subtitle
- Footer
- Reference line expression.
About GetObjectField()
