I have a bar graph with dimension as Year, and expression as the sum of sales (pretty straight forward graph). Now, my client wants to see the decrease in % of sales for all years relative to the best year as a error bar on top of the original bar. In other words, just take the sales for the best year subtract by that year's sales as the error bar (i.e. if best year sales is 10000, then expression for error bar is = 10000 - sum(SALES)), further, maybe on top of the error bar show the decrease in %. However, I am having the below issues.
1) Error bar doesnt work properly, if i type the expression in 'Error Above' , the bar extends to both above and below the bar (I only want it to extend on top). As a result, i have to set the 'Error below' expression = 0; however, when I do this, a legends pops up, and totally distorts the look and alignment of my graph. Any solutions?
2) I cannot get QlikView to show a number (% decrease in sales) for the error bar. I don't think this is possible, but if anyone knows how, please let me know.
I understand that it be much easier for you all to understand what I mean if I can paste the QlikView graph here, but I cannot get that to work. So if you prefer seeing the graph, please explain to me how to paste it here. Your help is truly truly appreciated!
Well, I'm not sure if this is an "error" bar per se, but seems to me to simply be a stacked bar chart.
Dimension: Time Expression 1: sum(Sales) (edit) Expression 2: max(total aggr(sum(Sales),Year)) - column(1) (edit) Expression 3 (uncheck "bar" so it's just a number and show values on data points): (max(total aggr(sum(Sales),Year)) - column(1))/max(total aggr(sum(Sales),Year))
Then set the style to stacked. This should work, unless I've misunderstood your requirements.
Thank you for your answer. Althought it sore of does what I want it to do, my client is very picky with the presentation of the information. In other words, he doesn't want to the 'error bar' as a stacked bar, because it gives the impression that these are the forcasted sells or something, he would like to see the 'error bar' (the decrease in sales bar) to have different physical properties, say smaller in width or dashed? And I could do that to line graphs by changing the 'Line Style' properties, but doesn't work for bars?
Further, he wants to see both the numbers of sales (which is done by pressing 'Valus on Data Points' button of the sales expression) plus the decrease in sales in % as numbers; however, the original number of sales that were shown before gets 'blocked' by the new bar (the percentage bar that you suggested). How do I go about that issue?
Sorry for being so picky (this is a strange client), but I cannot fix this problem myself, your help is truly appreciated.
