conditional display of one object based on field selected in other

[#1]

Hi,

have you experienced such a problem? I want to conditionally display one box (input box with variable, but that's not important) based on which dimension from cyclic group is selected in other object. Is that possible at all?

getcurrentfield does not help because it does not relate to that other object..

[alexandros17]

Yes, with getcurrentfield you can read the selected field in a cyclic or drill Group, you need however to condition other objects with the field read ...

[christian77]

Hi.

That's getcurrentfield(YourGroup)

luck.

[salto]

Hi,

yes, getcurrenfield(Dimension_Name) will help you with this request.

Set the condition to view the object to:

GetCurrentField (Dimension_Name)='DesiredValue'

That should work.

[#5]

Hmm i don't success with getcurrentfield. Can you try on the attachment please? I want the test text box to be displayed only when there is Month selected in the middle chart.

Thanks a lot

[jerem1234 · Accepted solution]

You needed to remove the single quotes on your group:

GetCurrentField(dim)='Month'

PFA

Hope this helps!

[#7]

Thanks, works well:)

J.

[#8]

Ahh i know what was the real cause of my problem in the original dashboard. The getcurrentfield function does not help because in the cyclic group i have calculated dimensions. Is there a chance to use successfully getcurrentfield too? Thanks.

[jerem1234]

Think it should work, but what get current field returns is the formula. So if you had a calculated dimension in your group, for example month(Month), what GetCurrentField() will return will be '=month(Month)'. So an if statement like

=GetCurrentField(Group)='=month(Month)'

should work. If you have trouble finding what it returns, just put GetCurrentField(Group) into a textbox and cycle through your group.

Hope this helps!