here's my problem:
I have two calculated dimensions "eMyCalcDimension1" and "eMyCalcDimension2" in a group "mygroup"
getcurrentfield(mygroup) returns "=$(eMyCalcDimension)" when shown in a text box. (without the quotes)
I am trying to use the function "getcurrentfield(mygroup)" to conditionally change the help text on a chart based on the active group dimension in a cyclic group.
I have put this function in my help text expression:
=if(GetCurrentField(mygroup) = '=$(eMyCalcDimension1)', 'This is help text 1', 'This is help text 2')
this returns null
i have tried using the label instead with no success, I have tried almost every variation of the variable name without the = or $,(,), etc... none work the way expected. I'm guessing there is some way to include special characters like '=$()' into a string literal without it trying to evaluate the expression??
please help me! or if this is something qlikview simply cant do let me know so I stop going crazy ='(