# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Highlighted
Not applicable

## Qlikview Dimension Calculate

Hi !
I would like to know if it is posible to calculate a dimension like this:
I have a table with only this

Country_Sells:

Country, Import

Espain, 1000

France, 2000

Argentina, 500

];

I can create this graph !

But I would like to create a a new value for country . I would like to create "UE" , this will be the sum of ESPAIN + FRANCE.

Is there any chance I can do this???

Thank you very much!!!!

Tags (2)
1 Solution

Accepted Solutions
Partner

## Re: Qlikview Dimension Calculate

Hi Rodrigo

yes, 2 solutions :

you can add a field in your script like if (Country ="Spain" or Country="France", "EU", otherValue) as MetaCountry

or use the same formula as Calculated Dimension in the chzart

best regards

11 Replies
Partner

## Re: Qlikview Dimension Calculate

Hi Rodrigo

yes, 2 solutions :

you can add a field in your script like if (Country ="Spain" or Country="France", "EU", otherValue) as MetaCountry

or use the same formula as Calculated Dimension in the chzart

best regards

Not applicable

## Re: Qlikview Dimension Calculate

Hi juju,

The problems is  that i still want to see spain, france  but I will like to add UE en a column

Something like this

As I undestand your solutions, I would only see UE and Argentina with the MetaCountry Dimension. Did I undestood wrong?

Thanks a lot for your help!

PD: the value for EU is 3000. The sum of  France (2000) and Espain (1000). I wrote 1500, but is wrong !!!!

Valued Contributor

## Re: Qlikview Dimension Calculate

If you really want that type of display in your chart I think you need to introduce another table that duplicates up your countries;

Country_Map:

Country, Country_Region

Espain, Espain

France, France

Argentina, Argentina

Espain, EU

France, EU

];

Partner

## Re: Qlikview Dimension Calculate

No you will see both

you keep your field country (FR, SP, ARG...) and you have a above hierarchical field like Region with EU, ARG

best regards

Valued Contributor

## Re: Qlikview Dimension Calculate

Can't get the image to insert - but shown on QVW.

Not applicable

## Re: Qlikview Dimension Calculate

Geniusssss !!!

Will you marry me?? jajajajajaaj

Thanks a Lot  my friend !!!!

Not applicable

## Re: Qlikview Dimension Calculate

Hi Chistopher !

I am sorry but I need a little more help..
When I use this solution the partials SUM does not work correctly when I expand or compact the PIVOT GRID.

Can you help me to finish solve this problem?

Thanks !!

Partner

## Re: Qlikview Dimension Calculate

Hi Rodrigo

Or much more like this

Best regards

Christian JUILLARD | Sr Manager EIM, France | Cognizant

1-3 rue du Château | 92200 Neuilly-sur-Seine | France

t. +33 (0)1 70 36 56 57 (direct xx) | m. +33 (0)6 21 89 03 94

e. christian.juillard@cognizant.com<mailto:christian.juillard@cognizant.com> | w. www.cognizant.com<http://www.cognizant.com/>

Not applicable

## Re: Qlikview Dimension Calculate

Hi JUJU !!
I understand your idea but I need  all toghether like this:

Country:
Argentina   500

men 400

women  100
Spain        1000

women 500

men 500

France      2000

men 1000

women 1000

Eu             3000

women 2000

men 1000

The problem I am having is when I contract the dimension.. The sum Is not the same.