topic Re: Change Chart Title Name based on selection on Cyclic Group in QlikView

Change Chart Title Name based on selection on Cyclic Group

soha1902 — Thu, 19 Feb 2015 10:34:52 GMT

Hi All,

I need to change my chart title name based on selection in Cyclic Group.

For example I am Showing Employee Salary, Region wise and City wise. So In Cyclic Group I added both dimensions.

Now when I select Region then Chart title will be "Salary Region Wise" and if I select City from Cyclic group then Title will be "Salary City Wise".

Please help me to solve this.

Thanks.

er_abhichandra — Thu, 19 Feb 2015 10:36:54 GMT

Hi Soha,

Use the GetCurrentField() function in QlikView to get the currently visible field in any group. The name of the group has to be given without quotes.

Thanks,

Abhinava

Thu, 19 Feb 2015 10:39:57 GMT

Hi,

You can use ='Salary ' & GetCurrentField(CyclicGroupName) & ' Wise'

Regards

Nandkishor S. Pandirkar

soha1902 — Thu, 19 Feb 2015 10:48:40 GMT

It showing error only.

I tried in Title Text box

=GetCurrentField(Com/TST)

where Com/TST my Group Name.

Please help

AbhijitBansode — Thu, 19 Feb 2015 10:51:10 GMT

It will show Syntax error but will give the valid output.

please ignore the syntax error.

Thu, 19 Feb 2015 10:56:36 GMT

Hi Soha,

you need to bracket round the group name as you have an operator in the name

=GetCurrentField([Com/TST])

Thu, 19 Feb 2015 10:58:06 GMT

Hi,

Use GetCurrentField([Com/TST])