topic Re: Show values on combo chart in QlikView

Show values on combo chart

Tue, 11 Nov 2014 10:38:32 GMT

Hi guys,

I am trying to show values on data points on a combo chart. I can do it on the "bar part" of the chart, but cannot do it on the "line part". You have the chart uploaded, along with the data. What I need is the numbers that are already there on the bar chart, plus the Scheduled Loads on the line chart, both in the same time.

PS: I have the free version, so I cannot open qvw created by others, therefore, if you can help me, try to explain me what you did or take some screenshots. Thanks!

Re: Show values on combo chart

senpradip007 — Tue, 11 Nov 2014 10:45:44 GMT

Go to Expressions tab select the line expression and then check "Value on Data Point". It will help you.

Re: Show values on combo chart

Tue, 11 Nov 2014 10:50:14 GMT

I know this. It's not what I want. It will show me 100% because of how it's calculated. I want to show the integers. Please open the qvw and familiarize yourself with the data and the chart (it's really simple), maybe you could come up with a solution.

Thanks

Re: Show values on combo chart

morganaaron — Tue, 11 Nov 2014 11:01:15 GMT

Hi Adrian,

Not quite what you're looking for, but if you change your expression to provide the values you could include both values, for example:

sum([Actual Loads]) & ' out of ' & sum([Scheduled Loads])

would provide both your figures in the same place. Adding another expression is going to put your values in the same place as the other expression.

Re: Show values on combo chart

raviityou — Tue, 11 Nov 2014 11:08:50 GMT

hi,

hope this will help you

check the Value on Data Point --- it will show the values on data point make sure you selected You Expression on which you want to show values.

In this example your using number format with Percentage

that's why it show the values in 100%.

Re: Show values on combo chart

Tue, 11 Nov 2014 11:17:24 GMT

I've done this as well. I wanted to know if it's a way to either to "reformat" the chart or to use the same formatting but display, instead of 100%, the actual number?

Re: Show values on combo chart

raviityou — Tue, 11 Nov 2014 12:00:17 GMT

Go to Number Tab and Uncheck the Show in percentage(%). it will show the actual no.