topic Re: Percentage Value on Data Point - Stacked Bar chart in QlikView

Percentage Value on Data Point - Stacked Bar chart

Fri, 28 Aug 2015 14:51:37 GMT

In the attached sample doc, I'm using a stacked bar chart to show counts of customers with positive vs negative sales. Customers with positive sales show above the 0 mark and companies with negative sales show below. I also want to show the % of total customers per month in the 'positive' above each month's bar. I added a 3rd expression to do this, but the value I'm getting is the count of the positive customers plus 1 (is it adding the percentage value to the count and rounding?? if so why??). However, in the pop-up text, i'm getting the correct percentage value.

Can anyone help me figure out how to get the accurate percentage to show on the chart?

P.S. I have been able to get closer to what i want, but then it was showing the same (positive) !percentage above and below. I want either the corresponding percentage above/below, or just the positive percentage (since the inverse can be inferred)

Re: Percentage Value on Data Point - Stacked Bar chart

Anonymous — Fri, 28 Aug 2015 17:50:42 GMT

Hi Ashley,

I tried to solve your problems, but I don't know if I understand all of them.

About the plus 1 customer that is missing, is because the expressions are GrossSales = {'>0'} or GrossSales = {'<0'}, so the GrossSales = 0 are not counting.

Also, I guess is not possible to put the value and '% 'above the bars, so I put the '% 'above and the value in the axis.

Best Regards

Re: Percentage Value on Data Point - Stacked Bar chart

Fri, 28 Aug 2015 17:55:23 GMT

Thanks, but i'm not trying to have both. I just want the percentage above the bar and it always comes out as the actual count value +1 instead of percent of the total. It's ok to exclude those with 0 sales because i'm only looking at those with positive or negative sales.

Re: Percentage Value on Data Point - Stacked Bar chart

Anonymous — Fri, 28 Aug 2015 18:37:36 GMT

Hi,

I don't know if is possible above the bar, but I put in the middle.

I didn't understand the second part "always comes out as the actual count value +1 instead of percent of the total"? The percentage is okay, isn't it?

Best Regards

Re: Percentage Value on Data Point - Stacked Bar chart

Anonymous — Fri, 28 Aug 2015 18:55:44 GMT

Right Mauri. Not sure if we can plot expression data point on the top of the bar and expression you put looks promising.

Re: Percentage Value on Data Point - Stacked Bar chart

swuehl — Fri, 28 Aug 2015 19:00:29 GMT

Maybe like attached?

You said the invese can be inferred, but I think your current calculation misses the case GrossSales = 0. That's why the sum of Met and not met will not add up to 100%.

Re: Percentage Value on Data Point - Stacked Bar chart

NickHoff — Fri, 28 Aug 2015 19:14:50 GMT

Try count address number/count(total address number) with all options for the chart deselected except for show value on data points.

Re: Percentage Value on Data Point - Stacked Bar chart

MarcoWedel — Sun, 30 Aug 2015 23:35:05 GMT

Hi,

another solution maybe could be to replace the text representation of the first expression with the percentage value using the dual() function:

hope this helps

regards

Marco

Re: Percentage Value on Data Point - Stacked Bar chart

Thu, 03 Sep 2015 16:51:00 GMT

ok, so this works, but why does it only work if you 'plot values inside segments', but give a different value when you don't check that box and let the values display above the bars?