topic Re: Bar Chart - Case Sensitive on dimension in QlikView

Bar Chart - Case Sensitive on dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

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).

Many thanks.

Greets,

Rega

Re: Bar Chart - Case Sensitive on dimension

sunny_talwar — Thu, 26 May 2016 11:17:58 GMT

Change your dimension from DeliveryCity to -> Capitalize(DeliveryCity)

Re: Bar Chart - Case Sensitive on dimension

swuehl — Thu, 26 May 2016 11:20:34 GMT

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:

Data Cleansing

Re: Bar Chart - Case Sensitive on dimension

Anonymous — Thu, 26 May 2016 11:21:22 GMT

Hi Rega

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.

Kindest Regards

Brian