Discussion Board for collaboration on QlikView Layout & Visualizations.
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,
can you share your app ?
No youssef as i am working on remote desktop.
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..
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.
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.
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.