Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try like this
Chart: Barchart
Dimension: YEAR, MonthGroup, TYPE
Expression: =Sum(Value)/Sum(TOTAL<YEAR, MonthGroup> Value)
Hope this helps you.
Regards,
jagan.
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.
You have to change the expression...
SUM(CRE_PAID_AMOUNT)/sum(TOTAL <PAID_YEAR,PERIOD>CRE_PAID_AMOUNT)
Thanks a lot
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.