Bar Chart

[upaliwije]

Hi Friends

I have some data in the following table and I want to create bar chart in QV with the data in the table

YEAR	TYPE	MAY-JUN-JUL	OTHER-MONTHS
2013	A	40,017,693	125,167,132
2013	B	938,739,804	2,474,358,841
2013	C	23,725,418	74,356,983
2013	D	2,505,441	1,104,019
2014	A	32,453,750	127,146,085
2014	B	819,656,714	2,190,669,436
2014	C	38,339,791	105,759,591
2014	D	214,836,239	450,894,057
2015	A	52,992,681	83,557,779
2015	B	930,098,574	2,502,012,638
2015	C	42,550,921	119,393,652
2015	D	251,770,244	613,886,830

In the chart I have in my mind I want the following

X axis should represent  years and two bars for 1. MAY_JUN_JUL

                                                                     2. OTHER MONTHS

Two Bars should have relative % amount shown above representing type A B C and D

Pls help me to create this chart with a sample QV document

[jagan]

Hi,

Try like this

Chart: Barchart

Dimension: YEAR, MonthGroup, TYPE

Expression: =Sum(Value)/Sum(TOTAL<YEAR, MonthGroup> Value)

Hope this helps you.

Regards,

jagan.

[upaliwije]

Thanks Manish

Your reply perfectly matches my requirement. In my actual QV document Bars are of different length. Pls help me to correct it I have attached my QV.

[MK_QSL · Accepted solution]

You have to change the expression...

SUM(CRE_PAID_AMOUNT)/sum(TOTAL <PAID_YEAR,PERIOD>CRE_PAID_AMOUNT)

[upaliwije]

Thanks a lot

[jagan]

Hi,

You should not use {} for Total parameters, try below expresison

SUM(CRE_PAID_AMOUNT)/Sum(TOTAL <PAID_YEAR,PERIOD> CRE_PAID_AMOUNT)

It is working as expected.

Regards,

Jagan.