Discussion Board for collaboration related to QlikView App Development.
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
Can you try this:
Sum($(=GetCurrentField(Demographics)))/Sum(TOTAL <Year>$(=GetCurrentField(Demographics)))
Can you try this:
Sum($(=GetCurrentField(Demographics)))/Sum(TOTAL <Year>$(=GetCurrentField(Demographics)))
Thank you! I never understand why some syntax works better than others in certain situations... Could you possibly elaborate?
Thanks again!!
Joe
Hi,
check changing your variable like this,
vDemopick=GetFieldSelections(Demographics)
HTH,
Hirish
maybe you have some space in the fields of the group
try with
='[' & GetCurrentField([Demographics]) & ']'