Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)

1 Solution

Accepted Solutions
marcus_sommer

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

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