Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to know if a dimension is displayed in Chart

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

1 Solution

Accepted Solutions
Contributor III
Contributor III

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

View solution in original post

2 Replies
Partner
Partner

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/FieldFunc...

 

I hope that helps!

Kind regards,
Stoyan

Contributor III
Contributor III

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

View solution in original post