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!
