I'm new in QlikView and would like to display only the total value of the sum of the values of the same bar in a stacked bar chart.
When I select "Show Total", the graph shows the total value above all other values as shown in the image below:
I just want to ignore the other values and show just the total.
Create one expression( Mostly the same as the one which you have). Remove the Bar option ans select the "Values on Data Point" Option.
As previously stated, another expression is needed to represent the total. If the total expression you have now is the true total, you can use that one but do not set as bar - if you do, you are then adding a total bar on top of all of the stacked bars that make up the total. Select Show values on datapoint for the total expression (with no bar)
Thanks guys for your tips... Now i have only the total number at the top of all the stacked bars, as shown in the image below:
But i still see the others bars right below the total (orange).
I need to remove all, not only the values, and display only the orange, which is the total.
it sounds like you want a bar chart that just shows total (a bar by assignment type) and no type of visual breakout by PharmaBrasil?
I would recommend you remove the orange bar but leave the total and show the other below - this will give you a visual view of the makeup of the total, with the total number, but doing what you want is possible - it would involve the total expression by assignment type
can you provide the qvw?
1 dimension with 4 expressions in style we select stack with values on data points...it shows like as shown in the image...now we right click on the chart presentation tab uncheck the plotedinside the segments..it shows total values in outside the each bar