Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
I hope that helps!
Kind regards,
Stoyan
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