Change Chart Title Name based on selection on Cyclic Group

[soha1902]

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]

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

[#3]

Hi,

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

Regards

Nandkishor S. Pandirkar

[soha1902]

It showing error only.

I tried in Title Text box

=GetCurrentField(Com/TST)

where Com/TST my Group Name.

Please help

[AbhijitBansode]

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

please ignore the syntax error.

[#6 · Accepted solution]

Hi Soha,

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

=GetCurrentField([Com/TST])

[#7]

Hi,

Use GetCurrentField([Com/TST])