Can you sum several dimension values in a bar chart?

[dan205]

Let's say I have a simple bar chart like the example from the Qlik help, where the dimension is country and the measure is an expression (e.g. price*quantity):

Is it possible to include another bar on the same chart that shows the total for UK, Spain and Germany? 

Thanks in advance,

Dan

[Chanty4u]

Try this 

Sum({<Country = {'UK', 'Spain', 'Germany'}>} Price * Quantity)

[vinieme12]

Create a new field with custom grouping to use as dimension in chart

Then use Country_dim as chart dimension

CountryGrouping:

Load Distinct Country as Country, Country_dim

From FactTable;

Concatenae(CountryGrouping)

Load Distinct Country as Country, 'EUROPE' as Country_dim

From FactTable

Where wildmatch(Country,'UK','Spain','Germany') ;

[dan205]

Thanks @Chanty4u and @vinieme12 - I've been put on another project but I will try both of those solutions at the earliest opportunity and report back. 

Dan