Stacked bar chart without dimension - QlikSense

[AriIt]

Hello everyone!

I need to make a stacked bar chart but I don't have the dimension.

On the X-axis I need to put for example: London, England, Europe (so 3 bar), and on the Y-axis: 'Provided per user', 'Provided per user (England)', 'Provided per user ( Europe)' and 3 more measures: 'Provided per capita', 'Provided per capita (England)', Provided per  capita (Europe)'.

Thanks for your reply!

[joaopaulo_delco · Accepted solution]

Hi @AriIt !

    I think the best way is using the "ValueList" function. Se the example below.

//Dimension:
ValueList('London','England','Europe')

//Measures:
if(ValueList('London','England','Europe') = 'London', Sum(ValueLondon),
if(ValueList('London','England','Europe') = 'England', Sum(ValueEngland), Sum(ValueEurope)))

I hope to help you!