topic Re: How to know if a dimension is displayed in Chart in App Development

How to know if a dimension is displayed in Chart

girard_ben — Fri, 02 Apr 2021 08:15:08 GMT

Dear All,

is there a function to know if a dimension is displayed in a Chart ?

I'm using lots of "Show/Hide" capabilities and the "Custom report" from Vizlib and I'm looking if there is a way to now if a specific dimension is displayed or not.

regards

Benoît

Re: How to know if a dimension is displayed in Chart

Stoyan_Terziev — Tue, 14 Jan 2020 09:53:43 GMT

Hi Girard,

The GetObjectDimension should do the trick for you.

But keep in mind you cannot use this to display the content. Aka - you cannot put it in the Title or so. BUT you can use it as a condition to control color-coding or even how expressions are calculated.

You can check this article:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunctions/getobjectdimension.htm

I hope that helps!

Kind regards,
Stoyan

Re: How to know if a dimension is displayed in Chart

girard_ben — Tue, 14 Jan 2020 17:01:13 GMT

Hi Stoyan

Perfect, with concat it could be very powerfull... why Qlik did not had an official function for that...

=if(SubStringCount( concat(distinct GetObjectField(ValueList(0,1, 2, 3, 4,5,6,7,8,9,10,11,12,13,14,15)), ','),'Year Month')=1,'Year Month is displayed' ,'Year Month is hidden')

have a nice evening !

Regards

Benoît