Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sum the bars in bar chart and show it as a single bar

hi,

I have a bar chart that shows sum of amount by department

it Shows sum of amount by  department (in shows 10 bars of 10 different department)

I want a bar chart that displays a single bar

5 Replies
Anonymous
Not applicable
Author

Go to Style tab and select Subtype as Stacked

Not applicable
Author

PFA.

Not applicable
Author

You can try with the following expression:

sum(all revenue)

prashantbaste
Partner - Creator II
Partner - Creator II

Hi

Use of stack type bar chart will be more suitable for you.

So that you can have a single bar against multiple departments with indicator of separate color for seperate department.

Hope this will be helpful for you.

--

Regards,

Prashant P Baste

awhitfield
Partner - Champion
Partner - Champion

HI Gaurav,

can you use a stacked chart in stead of grouped?

Andy