topic Re: total on bar chart in QlikView

total on bar chart

clovati — Mon, 30 Mar 2015 08:25:43 GMT

how can i show total on bar chart

Re: total on bar chart

arulsettu — Mon, 30 Mar 2015 08:34:59 GMT

Hi,

For Example in barchart properties in expression write like this

sum(sales)

Re: total on bar chart

arulsettu — Mon, 30 Mar 2015 08:36:20 GMT

or you expecting this

Goto to general tab in chart properties -->check show title in chart--> give your expression

Re: total on bar chart

Mon, 30 Mar 2015 08:38:22 GMT

Hi,

In expression tab check the values on data points.

Re: total on bar chart

clovati — Mon, 30 Mar 2015 08:41:26 GMT

I thinkl I should be able to select the red options... but I'm not! THANKS!!!

Re: total on bar chart

Mon, 30 Mar 2015 08:48:37 GMT

Hi,

You can try another one.

First go to chart properties-->> expression tab-->> presentation tab.

It is in expression tab.

This is in presentation tab, check this.

Re: total on bar chart

arulsettu — Mon, 30 Mar 2015 08:51:37 GMT

If you're using QV11 you may have the option Show Total on the Dimension Limits tab enabled. If you uncheck that option the total bar would go away. In Qlikview 10 the option is located on the Presentation tab.

Re: total on bar chart

Mon, 30 Mar 2015 08:51:39 GMT

Hi,

That is available only for straight tables.

you can see this

Re: total on bar chart

sujeetsingh — Mon, 30 Mar 2015 08:54:47 GMT

you can add an expression for calculating Total and set Values on data points for that expression. Make it a line expression and set the line chart transparent.

Re: total on bar chart

Mon, 30 Mar 2015 09:05:40 GMT

hi try this in your file

you can get total on bar chart

Re: total on bar chart

clovati — Mon, 30 Mar 2015 10:17:39 GMT

Thanks in advance!

Why is it giving me only one total for (CUMUL n-1 +CUMUL REEL)? A the end I have just one bar. I expected one total for Cumul n-1 and one total for CUMUL REEL

Re: total on bar chart

clovati — Mon, 30 Mar 2015 10:24:45 GMT

It is not enabled 😞

Re: total on bar chart

Mon, 30 Mar 2015 10:30:59 GMT

Hi,

I think, you can put total only one expression. You can put total for two expressions .