Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graphic title based on a cyclic group (with variables)

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

LC

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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')))


talk is cheap, supply exceeds demand
Not applicable
Author

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).