Discussion board where members can get started with QlikView.
in the image below you see the total ordered in cities. As you can see the city Amsterdam and AMSTERDAM appears in this chart.
I would like to create one dimension value into Amsterdam. How can you fixed a case sensitive dimension value?
the current expression of Total Ordered is Sum(total ordered).
Change your dimension from DeliveryCity to -> Capitalize(DeliveryCity)
I would suggest to do this already when loading in your data, if your conditions of spellings are a more complex, you can also look into a MAPPING approach:
Is it only Amsterdam that you have two values for? If it is you could try this in your load script where you load the city field.
If(City='AMSTERDAM','Amsterdam',City) as City this will give you just the one value for Amsterdam. Hope this is useful for you.