Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jtanguay
Creator
Creator

Stacked bar chart help

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:

sales graph.png

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

5 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
jtanguay
Creator
Creator
Author

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

Gysbert_Wassenaar

You can try using the Bar Offset setting.


talk is cheap, supply exceeds demand
jtanguay
Creator
Creator
Author

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

Gysbert_Wassenaar

Please post a qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand