Changing Field's Value Name

triekong — Tue, 03 Oct 2017 21:40:17 GMT

My dataset contains values for Vegetables and Sales.

The problem is some of the values in the Vegetables column begin with a lower case 'k', while others begin with a capital letter 'K'. this means when i input my chart, for vegetables and sales, i have 2 bars for 'Kale'. Instead, i would like just 1 bar, where the sales for 'Kale'= sales for 'kale' + sales for 'Kale'.

I previously used this method, renaming a specific value when loading the data and it worked,but would like to change it and use maybe an 'if' statement for the specific field in the script load. Let me know if there is a work around for this.

i have attached the qlikview document as well.

Vegetables	Sales
Kale	300
Spinach	70
Waterleaf	200
kale	10

thanks!

Re: Changing Field's Value Name

rwunderlich — Tue, 03 Oct 2017 21:53:01 GMT

in your script:

Capitalize(Vegetables) as Vegetables

-Rob

topic Re: Changing Field's Value Name in QlikView

Changing Field's Value Name

Re: Changing Field's Value Name