- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you sum several dimension values in a bar chart?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Sum({<Country = {'UK', 'Spain', 'Germany'}>} Price * Quantity)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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') ;
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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