topic Re: Cyclic Group variable not working in QlikView

Cyclic Group variable not working

Wed, 17 Feb 2016 18:17:54 GMT

Hi everyone,

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

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

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

Re: Cyclic Group variable not working

sunny_talwar — Wed, 17 Feb 2016 18:36:03 GMT

Can you try this:

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

Re: Cyclic Group variable not working

Wed, 17 Feb 2016 18:43:50 GMT

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

Thanks again!!

Joe

Re: Cyclic Group variable not working

HirisH_V7 — Wed, 17 Feb 2016 18:45:30 GMT

Hi,

check changing your variable like this,

vDemopick=GetFieldSelections(Demographics)

HTH,

Hirish

Re: Cyclic Group variable not working

maxgro — Wed, 17 Feb 2016 18:50:50 GMT

maybe you have some space in the fields of the group

try with

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