topic 2 values/measures on a datapoint? in QlikView

2 values/measures on a datapoint?

Fri, 11 Mar 2011 00:10:33 GMT

Hi there,

I have a Bar chart, which I would like to show both the actual value as a number and a percentage on the bar.

I have tried playing around with the data-points, and all the options on the 'Expressions' tab, but have only managed to come up with the following(see image)

Ideally, there must be a way in which you can have 2 measures/values on a bar?

Any ideas?

Thanks![:)]

2 values/measures on a datapoint?

Miguel_Angel_Baeyens — Fri, 11 Mar 2011 00:44:23 GMT

Hello,

Do you mean "two measures in the same bar" (in your case above, only one bar, red and blue)? If so, go to the chart properties, Style, and select "Stacked" instead of "Grouped". That should do.

Hope that helps.

2 values/measures on a datapoint?

Fri, 11 Mar 2011 02:19:05 GMT

Well, no. I mean, 2 values/data points on 1 bar, but the same measure/expression.

So, in my case, I'd like to see both the % values and the number on 1 bar(data-point).

Not sure if this is possible.?

2 values/measures on a datapoint?

Fri, 11 Mar 2011 07:27:28 GMT

Hi, Check the QVW that i attached. One mot=re thing, in "Sheet Properties",pesentation tab,"Value on Data Points" category , u need to check the "Vertical" , to get values as u wish.