Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator III
Creator III

expanding the string

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)

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP

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

View solution in original post

1 Reply
marcus_sommer
MVP
MVP

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