topic Re: stacked bar chart in QlikView

stacked bar chart

upaliwije — Wed, 30 Mar 2016 09:55:08 GMT

I want to create a stacked bar chart in My qv document attached herewith. I want to to have two bar chart for Actual and budget.

In the each bar chart % of items give should appear. Pls help me to do this from QV document

Re: stacked bar chart

sunny_talwar — Wed, 30 Mar 2016 10:04:45 GMT

You want a stacked bar chart or you don't want a stacked bar chart?

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 10:06:09 GMT

Yes I want a stack bar chart with two separate bars for actual and budget

Re: stacked bar chart

sunny_talwar — Wed, 30 Mar 2016 10:09:06 GMT

I think may not be possible to do with two dimensions and two expressions. Can you may be remove the MONTH dimension? or is that something you would need to see?

Re: stacked bar chart

Wed, 30 Mar 2016 10:10:34 GMT

Hi,

Stacked bar chart is shown in the qvw provided. If you want grouped bar chart, then remove one dimension (Month in your case).

Regards,

Anjali Gupta

Re: stacked bar chart

MK_QSL — Wed, 30 Mar 2016 10:12:41 GMT

Like this?

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 10:12:44 GMT

No harm Month can be removed

Re: stacked bar chart

Wed, 30 Mar 2016 10:19:08 GMT

if Month is removed then your task is done.

Re: stacked bar chart

sunny_talwar — Wed, 30 Mar 2016 10:22:46 GMT

Then I think you just need to remove Month and change from Stacked to Group on the Style tab

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 10:31:43 GMT

Your one is some what equal to what I want . Bud the bar should represent % of Come as follows. If we go only upto Gross Profit level

INCOME	5,350,000
CEDED	970,000	18%
UPR	400,000	7%
NET_CLAIMS	2,000,000	37%
ACQ_COST	450,000	8%
GROSS_PROFIT	1,530,000	29%

Total % should be equal to 100%

Re: stacked bar chart

MK_QSL — Wed, 30 Mar 2016 10:39:22 GMT

Try this..

Total is now 100% because UPR has -3%

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 11:17:09 GMT

Thanks Manish

Slight change I do want to income to show in this chart. but how the % Income is divided among other items like

follows

CEDED	970,000	18%
UPR	400,000	7%
NET_CLAIMS	2,000,000	37%
ACQ_COST	450,000	8%
GROSS_PROFIT	1,530,000	29%

Pls help

Re: stacked bar chart

MK_QSL — Wed, 30 Mar 2016 11:35:15 GMT

I am not getting. Can you let me know exactly how you want to show % and what are the descriptions you are going to consider.

If possible, provide an excel with result. I will surely do my best to help you.

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 11:43:51 GMT

This is what I want

out of Total Income of 5,350,000

Ceded is 970,000 that is 18% of income (5350000)

UPR is 400,000 7% of income

Net Claim 2000000 37 %

....

Like wise total come to 100% .

Re: stacked bar chart

MK_QSL — Wed, 30 Mar 2016 12:01:22 GMT

Still you are not giving me full data..

.....

I will not understand what else DESCRIPTION you want to cover..

Kindly provide an excel..if possible

Also, UPR is -400,000 not 400,000. Please clarify !

Re: stacked bar chart

Wed, 30 Mar 2016 12:55:11 GMT

Hi ,

If sum Budget = Total Income ( i.e, 5,350,000) for the below data

say if (970,000 + 400,000+2,000,000 + 450,000+1,530,000 = 5,350,000)

CEDED	970,000	18%
UPR	400,000	7%
NET_CLAIMS	2,000,000	37%
ACQ_COST	450,000	8%
GROSS_PROFIT	1,530,000	29%

then you can add one more expression =sum(Budget) and check relative checkbox, you will get the %age

Re: stacked bar chart

Wed, 30 Mar 2016 13:08:24 GMT

Do you want this upaliwije ?

If yes, PFA.

Re: stacked bar chart

upaliwije — Wed, 30 Mar 2016 15:54:14 GMT

Thanks

I have attached excel sheet. What I want is to show how Income is divided among other items

Re: stacked bar chart

upaliwije — Thu, 31 Mar 2016 03:11:39 GMT

Sorry I could not attach excel sheet

Re: stacked bar chart

MK_QSL — Thu, 31 Mar 2016 07:37:04 GMT

Still you didn't clarify between -400,000 and 400,000