Dynamic label in QS Pivot Table - a hidden feature ?

pablolabbe — Thu, 15 Dec 2016 21:35:48 GMT

´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

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

esteban_garcia — Mon, 19 Dec 2016 17:47:50 GMT

wwwooowww

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

dmitry909 — Fri, 31 Mar 2017 05:56:58 GMT

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

topic Dynamic label in QS Pivot Table - a hidden feature ? in App Development

Dynamic label in QS Pivot Table - a hidden feature ?

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

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