topic Re: Stacked bar chart help in QlikView

Stacked bar chart help

Anonymous — Wed, 06 May 2015 12:57:57 GMT

Hello,

I have created a stacked bar chart that I am looking to have the components % in each bar, with the total directly and dynamically above the bar. So far I have been able to create is:

I have an invisible bar above the chart with the data inside the data point. Is there a setting to allow the 53.1% and 57.8% to be directly above the light blue section? Also, I tried the value on axis and that did not meet to the user's liking.

Thank you,

Justin

Re: Stacked bar chart help

Gysbert_Wassenaar — Wed, 06 May 2015 14:16:43 GMT

See attached example.

Re: Stacked bar chart help

Anonymous — Wed, 06 May 2015 14:22:10 GMT

Hi Gysbert,

Thank you for the help, is there a way to reduce the space between the total at the top, and the bar chart? The user is looking to limit the white space between the total and the components of the bar chart.

Thank you,

Justin

Re: Stacked bar chart help

Gysbert_Wassenaar — Wed, 06 May 2015 14:28:49 GMT

You can try using the Bar Offset setting.

Re: Stacked bar chart help

Anonymous — Wed, 06 May 2015 14:54:34 GMT

Gysbert,

I am having difficulty bringing down the top bar's data point. I can move it up with no problem, but if I either input a negative value or using the expressions, I cannot seem to move down the data point. Any thoughts?

Here are my expressions if it helps:

Bottom Dark Blue -

=((Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY CHG IN CASE/STAT])+

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY CHG IN SUPP])+

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY CHG IN IBNR]))

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[DIRECT EARNED PREMIUM]))

Middle - Lighter blue -

=((Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY PAID LOSS])+

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY ALLOC EXPENSES])+

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY SALVAGE/SUBRO]))

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[DIRECT EARNED PREMIUM]))

Top invisible stacked bar which is the total of both:

=(Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[AY INCURRED W ALAE])/

Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [DATA ORIGIN]={'SMG'}, [NEW RENEW IND]={'COMBINED'}>}[DIRECT EARNED PREMIUM]))

Thank you for all the help so far,

Justin

Re: Stacked bar chart help

Gysbert_Wassenaar — Wed, 06 May 2015 15:55:05 GMT

Please post a qlikview document that demonstrates the problem.