topic Re: Value on data points in Bar chart in QlikView

Value on data points in Bar chart

shanky1907 — Wed, 13 Dec 2017 10:09:00 GMT

Hello All,

I have a stacked bar chart in which there are 2 Dimension - Team & Days Outstanding.

Thers is one expression count(Case ID).

Now, i have limited the Team dimension to Top 5. Also i checked the Total checkbox in Dimension limit tab for Team Dimension.

So everything is working well but Value is not shown in Total bar.

I might be missing a tiny thing here.

any help is appreciated.

Thanks in advance,

Shashank

Re: Value on data points in Bar chart

YoussefBelloum — Wed, 13 Dec 2017 10:32:12 GMT

Hi,

can you share your app ?

Re: Value on data points in Bar chart

shanky1907 — Wed, 13 Dec 2017 10:37:57 GMT

No youssef as i am working on remote desktop.

Re: Value on data points in Bar chart

Or — Wed, 13 Dec 2017 13:22:27 GMT

I've replicated the circumstances you described and I am getting the values plotted correctly:

I'm not sure what else might be causing your problem, and without the application in question, I'm not sure how to find out..

Re: Value on data points in Bar chart

shanky1907 — Wed, 13 Dec 2017 13:26:28 GMT

I found out that my Total is huge with respect to top 5 dimension values. So, the bar showing total is excedding thechart size and might be showing the value out of the area.

But this is happening only when i am using 2 Dimensions. With single dimension, it is fitting into the chart area and everything is good. I dont know its a bug or i am missing any logic.

Re: Value on data points in Bar chart

justinvchiang — Thu, 14 Dec 2017 17:04:27 GMT

You could change the label on the Show Total to be something like ='Total: '&count(caseid), then the amount would appear at the bottom at least

or maybe you could try adjusting the static max scale for the chart under Axes to accommodate your total bar.

Re: Value on data points in Bar chart

pipuindia99 — Tue, 26 Dec 2017 17:04:47 GMT

Hi,

Can you see the total values when you move the cursor to the bar?, if so then the values are huge or else you can write a separate expression for calculating the total and limit the number chars.