Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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