Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Luminary
Luminary

Dynamic label in QS Pivot Table - a hidden feature ?

´Hi everyone,

  It's known that Qlik Sense doesn´t allow us to create a dynamic label for dimensions or metrics in objects.

  But during my daily development, I found an unexpected behavior building an expression with dollar expansion like this

   $(=max(Year))

  I was building a pivot table and instead of copy and paste the above expression inside the expression box, I paste it in the label box by accident.

  To my surprise, it showed the result of the expression, not the text of the expression.

  After some testing, I found this behavior only works with labels of measures in the pivot table object. Just that place.

  The expression inside $() also works even if you pivot the measure to rows.

  Tested with QS version  2 and version 3.

  Perhaps our friends from Qlik, Josh Good‌‌ and Michael Tarallo mto can explain if we can make use of this hidden feature as a workaround for a dynamic label use case or it can stop working in a future release.

Best Regards,

Pablo Labbe

2 Replies
esteban_garcia
New Contributor

Re: Dynamic label in QS Pivot Table - a hidden feature ?

wwwooowww

Highlighted
dmitry909
New Contributor III

Re: Dynamic label in QS Pivot Table - a hidden feature ?

Thanks! This is a great trick! It's a pity, that we have no way to do this in simple table