topic How to Show grand total as bar in Bar Chart ? in QlikView

How to Show grand total as bar in Bar Chart ?

madhubabum — Thu, 02 Nov 2017 11:21:19 GMT

Hi All,

I am having the scenario like , Need to include Grand total as bar in the same bar chart on top.

Data :

Product, Sales

Product A, 100

Product B, 200

Product C, 300

Product D, 400

Note : I want to Display 'Grand Total as 1000' in my Bar chart, on top of the chart

Any suggestions ?

Regards,

Madhu

Re: How to Show grand total as bar in Bar Chart ?

sunny_talwar — Thu, 02 Nov 2017 11:22:24 GMT

Did you tried to check 'Total' on the Dimension limits tab?

Re: How to Show grand total as bar in Bar Chart ?

prma7799 — Thu, 02 Nov 2017 11:24:27 GMT

Go to Presentation >> Text in chart >> add your expression .

On your need you can place this at anywhere in your chart

Re: How to Show grand total as bar in Bar Chart ?

madhubabum — Thu, 02 Nov 2017 11:31:11 GMT

Yes, But no luck

Re: How to Show grand total as bar in Bar Chart ?

arvind_patil — Thu, 02 Nov 2017 11:32:08 GMT

Hi Madhu,

Please check below heck box: as Suggested by sunny‌

Thanks,

Arvind Patil

Re: How to Show grand total as bar in Bar Chart ?

sunny_talwar — Thu, 02 Nov 2017 11:37:09 GMT

Would you be able to share a sample where you are trying this?

Re: How to Show grand total as bar in Bar Chart ?

madhubabum — Thu, 02 Nov 2017 11:42:14 GMT

Hi Arvind,

Thanks for Help..

Here i am getting the Grand total in the bellow chart, But i want to show Grand total on top of the bar

Re: How to Show grand total as bar in Bar Chart ?

sunny_talwar — Thu, 02 Nov 2017 11:45:27 GMT

Try this

Create a new field in the script

Load * Inline [

Dim

];

and then try this

Dimension

Pick(Dim, Product, 'Total')

Expression

Sum(Sales)

Sort tab, use this expression

Only({1} Dim) and then sort this in descending order

also make sure that sort by text is also checked

uncheck everything else

Re: How to Show grand total as bar in Bar Chart ?

madhubabum — Thu, 02 Nov 2017 11:49:44 GMT

Thanks Sunny ,

Working perfect

Re: How to Show grand total as bar in Bar Chart ?

SteveInVT — Wed, 27 Mar 2019 17:14:57 GMT

Thank you so much, @sunny_talwar . This post helped me solve 3 different issues that I was having! I had no idea the Pick function could be used this way. Thanks again!