[HOW TO] Sum value of different words

[m_grieco]

Hello everyone,

I have a table with different name of city (ex: Matera, MT, Bari, BA etc...) , find attached picture as example.

My question is: how can I sum value of Matera + MT , Bari + Ba  ? 

I've tried with formula:  =sum(if(PROV_ATTIVITA='Matera' and PROV_ATTIVITA=MT', 0)) but with no success.

Which formula I have to use?

Hope I explained clearly.

Thanks in advance for your helps.

[sunny_talwar]

May be Clean the data in the script to create a new field and use that in your chart

[rwunderlich]

If those names are aliases, it's probably best to map them to a common name in the script.  If you are wanting to do something specific in the chart you showed, how about:

-sum(match(PROV_ATTIVITA, 'Matera', 'MT')>0)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[m_grieco]

thanks Rob for your answer, but I get an error. 

[Brett_Bleess]

Mario, have a look at the following Design Blog post, I think this may be the easiest way to go at things:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

Here is the base URL for the blog site in case you want to do further searching on your own for any additional info:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett