topic Changing Field Name Dynamically without Script Load in QlikView

Changing Field Name Dynamically without Script Load

triekong — Wed, 27 Sep 2017 19:59:07 GMT

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!

Re: Changing Field Name Dynamically without Script Load

sunny_talwar — Wed, 27 Sep 2017 20:05:23 GMT

May be this

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

Re: Changing Field Name Dynamically without Script Load

vishsaggi — Wed, 27 Sep 2017 20:06:30 GMT

May be this? Check attached.

Re: Changing Field Name Dynamically without Script Load

triekong — Thu, 28 Sep 2017 12:32:17 GMT

Thank you very much! it worked