topic Re: Bar Chart in QlikView

Bar Chart

upaliwije — Wed, 10 Feb 2016 05:39:18 GMT

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

Re: Bar Chart

avinashelite — Wed, 10 Feb 2016 05:53:14 GMT

Try like this :

1.Create a Bar chart > Add Dimension as YEAR and TYPE

2. Add expression 1.sum(MAY-JUN-JUL) >expression label >MAY-JUN-JUL

2.sum(OTHER-MONTHS)> expression label >OTHER-MONTHS

for both the expression check the relative option in the expression tab. Currently I don't have QV licence so could not build a sample app for the same.

Hope this info will help you

Re: Bar Chart

jagan — Wed, 10 Feb 2016 05:54:51 GMT

Hi,

Try like this

Script:

Temp:

CrossTable(MonthGroup, TempValue, 2)

LOAD *

INLINE [

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"

];

Data:

LOAD

SubField(TempValue, ',') AS Value

RESIDENT Temp;

DROP TABLE Temp;

Chart: Barchar

Dimension: MonthGroup, TYPE

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

In Style tab select Stacked and in number tab select Integer and Percentage.

Hope this helps you.

Regards,

jagan.

Re: Bar Chart

upaliwije — Wed, 10 Feb 2016 06:19:45 GMT

Thanks

But I have done it the way you have said But the Year does not come into the picture

Re: Bar Chart

avinashelite — Wed, 10 Feb 2016 06:22:42 GMT

could you please share the script and the bar expression what you have used so that we could check the same

Re: Bar Chart

upaliwije — Wed, 10 Feb 2016 06:32:49 GMT

My sample QV document is attached pls

Re: Bar Chart

jagan — Wed, 10 Feb 2016 06:41:58 GMT

Hi,

Can you attach sample chart that you required? So that it would be easier to understand.

Regards,

jagan.

Re: Bar Chart

upaliwije — Wed, 10 Feb 2016 06:55:50 GMT

T.qvw is attached But I want all bars of 100% in length is it possible ?

Re: Bar Chart

MK_QSL — Wed, 10 Feb 2016 06:57:18 GMT

Like this?

Re: Bar Chart

MK_QSL — Wed, 10 Feb 2016 07:11:55 GMT

have you check my reply?

Re: Bar Chart

jagan — Wed, 10 Feb 2016 07:38:31 GMT

Hi,

Try like this

Chart: Barchart

Dimension: YEAR, MonthGroup, TYPE

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

Hope this helps you.

Regards,

jagan.

Re: Bar Chart

upaliwije — Wed, 10 Feb 2016 07:51:50 GMT

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.

Re: Bar Chart

MK_QSL — Wed, 10 Feb 2016 08:52:31 GMT

You have to change the expression...

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

Re: Bar Chart

upaliwije — Wed, 10 Feb 2016 08:58:02 GMT

Thanks a lot

Re: Bar Chart

jagan — Wed, 10 Feb 2016 08:59:34 GMT

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.