Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AriIt
Contributor II
Contributor II

Stacked bar chart without dimension - QlikSense

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!

1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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!

 

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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!

 

Help users find answers! Don't forget to mark a solution that worked for you!