topic Re: Bar Chart in QlikView

Bar Chart

qlikviewaf — Thu, 07 Sep 2017 12:36:27 GMT

I Guys,

i created this bar chart with 1 dimension and 2 expression.

I would like to have on the same bar the 2 expression (sales + budget) , i used the option "Stacked" but i got the value cumulated of the 2 expression (3529 is the sum of budget+sales).

There's a way to have one single bar comparing the 2 expression values and avoid to have the cumulate value?

Thanks

Re: Bar Chart

sam_grounds — Thu, 07 Sep 2017 13:18:43 GMT

If we are talking about the total number at the top (I assume this because you can't combine bars without combining them :S )...

Chart Properties -> Presentation -> Plot values Inside Segments (tick this) and make sure that "Still Show Total on Top" is not enabled.

Also under the expression tab, make sure you have "Values on Data Points" enabled for each expression.

If I've misunderstood and you want them to overlay without summing up, then you don't want a stacked chart, just change the bar distance on the Presentation tab of the chart properties.

Good luck,

Sam

Re: Bar Chart

antoniotiman — Thu, 07 Sep 2017 13:32:48 GMT

Hi Antonio,

if You are using QV Version < 12, then see Attachment.

Regards,

Antonio