Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

Tags (1)
5 Replies
greeshma_k
Contributor III

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

Go to Style tab and select Subtype as Stacked

Not applicable

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

PFA.

Not applicable

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

You can try with the following expression:

sum(all revenue)

Partner
Partner

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

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

Partner
Partner

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

HI Gaurav,

can you use a stacked chart in stead of grouped?

Andy