Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cyclic Group variable not working

Hi everyone,

I am trying to use getcurrentfield= in order to use a cyclic group as a chart expression, here are the Dimensions:

dimensions.png

and is the expression (note that I am not using multiple expressions, just trying to explain what's going on):

expressions.png

I'm just curious as to why the EthFlag expression works but when I use a variable as a cyclic group, it does not. I have used text boxes to prove that the vDemoPick Variable works, and it shows up correctly when I cycle through the demographics, but when I put in into an expression it stops working.

Thanks guys!

Joe

1 Solution

Accepted Solutions
sunny_talwar

Can you try this:

Sum($(=GetCurrentField(Demographics)))/Sum(TOTAL <Year>$(=GetCurrentField(Demographics)))

View solution in original post

4 Replies
sunny_talwar

Can you try this:

Sum($(=GetCurrentField(Demographics)))/Sum(TOTAL <Year>$(=GetCurrentField(Demographics)))

Not applicable
Author

Thank you! I never understand why some syntax works better than others in certain situations... Could you possibly elaborate?

Thanks again!!

Joe

HirisH_V7
Master
Master

Hi,

check changing your variable like this,

vDemopick=GetFieldSelections(Demographics)

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
maxgro
MVP
MVP

maybe you have some space in the fields of the group

try with

='[' & GetCurrentField([Demographics]) & ']'