Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({<Country = {'UK', 'Spain', 'Germany'}>} Price * Quantity)
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') ;
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