expanding the string

surajap123 — Wed, 07 Oct 2015 12:22:28 GMT

Hi All,

I have a cyclic group which has list of fields and also a field in variable.

eg- ='$(vAliasField)'

This variable is perfectly expanded and the real field is shown in the cylic group drop down list.

The chart gets its caption by below expression-

eg-

GetCurrentField(CyclicGrp)

But, when the user switch to the variable in cyclic group, the chart caption is not expanded and chart caption look like below-

='$(vAliasField)'

How to modify the below expression to expand the above variable?

GetCurrentField(CyclicGrp)

Re: expanding the string

marcus_sommer — Wed, 07 Oct 2015 12:35:27 GMT

AFAIK the getcurrentfield-functions returned the text from the current group-member and if this is an expression or a variable they will be returned and also the additionally labeling from this group-member didn't help.

The only workaround seems to be to use a condition like:

if(GetCurrentField(CyclicGrp) = '$(vAliasField)', '$(vAliasField)', GetCurrentField(CyclicGrp))

I think the "=" sign within the group-expression needs to be removed for this because the match would otherwise go to '= '$(vAliasField)'' which is problematic because the multiple single-quotes.

- Marcus

topic expanding the string in QlikView

expanding the string

Re: expanding the string