topic Graphic title based on a cyclic group (with variables) in QlikView

Graphic title based on a cyclic group (with variables)

Fri, 19 Jul 2013 11:21:00 GMT

Hi,

I created several variables and I am using them in a cyclic group. Now I want to used the "friendly name" of the variable on my chart title (depending on the variable selected on my graphic).

How is that possible?

Thanks

Re: Graphic title based on a cyclic group (with variables)

Gysbert_Wassenaar — Fri, 19 Jul 2013 11:26:07 GMT

You can use the getcurrentfield function to get the name of the active field in the cyclic group. Something like

if(getcurrentfield(MyGroup)='ValueA','Description A',

if(getcurrentfield(MyGroup)='ValueB','Description B',

if(getcurrentfield(MyGroup)='ValueC','Description C')))

Re: Graphic title based on a cyclic group (with variables)

Fri, 19 Jul 2013 13:00:26 GMT

I´m using something like this:

=if(GetCurrentField(Mycyclicgroupname) = 'vABC', 'Peter',

if(GetCurrentField(Mycyclicgroupname) = 'vDEF', 'Anne'))

It seems like if the cyclic group name isn´t recognized (red underline).