Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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