topic Re: Bar Chart expression in QlikView

Bar Chart expression

Wed, 04 Mar 2015 14:48:36 GMT

Hi Team,

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?

Re: Bar Chart expression

agomes1971 — Wed, 04 Mar 2015 14:51:26 GMT

Hi,

play with the y-axis and maybe changing the units...

HTH

André Gomes

Re: Bar Chart expression

jpenuliar — Wed, 04 Mar 2015 14:55:15 GMT

Hi Jhansi,

you will have to untick "Plot values inside Segments" to show Values on top of Bars

Re: Bar Chart expression

JonnyPoole — Wed, 04 Mar 2015 15:08:13 GMT

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 .

Re: Bar Chart expression

Wed, 04 Mar 2015 18:14:05 GMT

I want to show Tota sum up value of all segments at the Top of each bar i.e Total Amount for all categories for each month.

Re: Bar Chart expression

Wed, 04 Mar 2015 18:15:26 GMT

Yes, We can achieve in this way. the problem is they will copy this graph as a Image , sure it is not going to copy Total Value at that time ..

Re: Bar Chart expression

Wed, 04 Mar 2015 18:18:43 GMT

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?

Re: Bar Chart expression

Wed, 04 Mar 2015 18:23:27 GMT

Hi,

I have attached sample file to check.

Re: Bar Chart expression

JonnyPoole — Wed, 04 Mar 2015 18:58:31 GMT

didn't see the file attached to attach:

1. click the full thread link: Bar Chart expression

2. then hit 'reply'

3. then hit 'advanced editor'

-> attach the file and post

Re: Bar Chart expression

Wed, 04 Mar 2015 20:10:02 GMT

!Hi,

not sure but you can try following solutuin

Re: Bar Chart expression

Thu, 05 Mar 2015 01:09:46 GMT

Hi Taras,

You gave me a good option, Now atleast i can able to show total value as shown below.

But it is showing 3 values as it contains 3 categories, How to eliminate this? I have attached sample report. Thank you.

Re: Bar Chart expression

JonnyPoole — Thu, 05 Mar 2015 02:21:57 GMT

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 !

Re: Bar Chart expression

sunilkumarqv — Thu, 05 Mar 2015 04:59:17 GMT

@@Plz check attached

Re: Bar Chart expression

Thu, 05 Mar 2015 08:18:52 GMT

Hi Jhansi,

Please check attached file.

Hope it will help you

Re: Bar Chart expression

Thu, 05 Mar 2015 18:46:11 GMT

That's a fantastic idea. Thanks a lot for your help...

Re: Bar Chart expression

Thu, 05 Mar 2015 18:48:37 GMT

Thanks to all for your cooperation. I got a solution.