topic REG: Cyclic Group - Name Change in QlikView

REG: Cyclic Group - Name Change

Thu, 16 Apr 2009 13:49:53 GMT

Hi Friends

In Qlikview Cyclic Group can we change the name in the caption /title as the group changes

For example

In a cyclic group - Location,Customer,Product are there.

If we click Location , "Location wise............... analysis "should come

similarly if we click Customer "..........................................................." some other heading should come.So on

Whether it is possible in Cyclic group.

thanks

Regards

Ashok Kumar

REG: Cyclic Group - Name Change

Anonymous — Thu, 16 Apr 2009 14:01:34 GMT

Well, if I get the question correctly, you could probably do the following:
You want to know what group member is selected in the cyclic group. This can be done using the GetCurrentField() function.

Based on this field name you could use a simple if statement in the chart caption to set the chart name, something like below for example:

=if(GetCurrentField(A)='F1','First group value', 'Second group value')

REG: Cyclic Group - Name Change

Thu, 16 Apr 2009 14:34:21 GMT

Hi jsn

Its the exact solution i needed.

It works...

Thanks a lot..

regards

Ashok Kumar