Discussion Board for collaboration related to QlikView App Development.
I want to show the Total Value for Each month at the top of the each bar. Eg: 1000 - at 0314 bar , 2000 - 0614 bar etc..
Can this possible?
ok. i got interested
i put this expression in the subtitle to space out the totals horizontally across the top
= concat( aggr(sum(total <ReportMonth> Value),ReportMonth) , Repeat(' ',160/count( DISTINCT ReportMonth)) ,ReportMonth)
hold down the CTRL/SHIFT key and click the chart ,you will see red lines and you can move the legend, title around as you see fit. i found the spacing works better if the legend is NOT on the side but play with it, maybe you can get it to work by pushing the title a little left off center.
in the expression above play with the '160' number if you resize the chart to space the totals right.
good luck !
Well - its a little tricky because you can either have all the data points inside the segments or on top and not both. I don't see a good way around it. If you are desperate you can go with the total kluge idea of overlaying 2 charts (see below and attached) . It may look ok but you'll spend a lot of time trying to get the charts working perfectly in unison so only do this if its impossible to visualize any other better way .
If i go for combo chart and having Second expression in chart might solve the problem. I used Aggr(sum(Total), Report_Month), but leading to entirely different view... can anyone try this?