Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
triekong
Contributor

Changing Field Name Dynamically without Script Load

i have a field in my dataset called 'sales.DryFruits' which i change in my script load to [Dry Fruits].

i have created a group in my chart called [Items] which is made up of 2 fields: [Dry Fruits] and [Flowers]

in my Chart Title i am changing the field dynamically by using the group 'Items', with the formula:

='Current Sales per ' & ' ' & GetCurrentField([Items])

Problem: in the label, i am trying to make it say [Fruits] instead of [Dry Fruit] without changing it in the Script Load. i want the field in the label to say [Fruit] but everywhere else in the report to say [Dry Fruits].

is there a formula or expression i can use to change this field dynamically in the Title bar? or maybe a workaround without using the script load?

thanks!

Tags (1)
1 Solution

Accepted Solutions

Re: Changing Field Name Dynamically without Script Load

May be this

='Current Sales per ' & ' ' & If(GetCurrentField([Items]) = 'Dry Fruits', 'Fruit', GetCurrentField([Items]))

3 Replies

Re: Changing Field Name Dynamically without Script Load

May be this

='Current Sales per ' & ' ' & If(GetCurrentField([Items]) = 'Dry Fruits', 'Fruit', GetCurrentField([Items]))

vishsaggi
Esteemed Contributor III

Re: Changing Field Name Dynamically without Script Load

May be this? Check attached.

triekong
Contributor

Re: Changing Field Name Dynamically without Script Load

Thank you very much! it worked