Bar Chart

[upaliwije]

Hi Friends

In my QV document have following data

DESCRIPTION	ACTUAL
GROSS_PREMIUM	3,000,000
CEDED	630,000
NET_CLAIMS	1,200,000
COMM	200,000
EXPENSES	500,000
NET_PROFIT	470,000

I want to show in a single bar of bar chart with representing % of CEDED.NET_CLAIMS,COMM,EXPENSES,NET_PROFIT  as against GROSS_PREMIUM

I have written under mentioned expression for but it is not working. Kindly help me to correct it

SUM({<DESCRIPTION={CEDED_PREMIUM,NET_CLAIMS,COMM,EXPENSES,NET_PROFIT}>}ACTUAL)/SUM({TOTAL DESCRIPTION=<'GROSS_PREMIUM'>ACTUAL)

[MK_QSL]

SUM({<DESCRIPTION = {'CEDED','NET_CLAIMS','COMM','EXPENSES','NET_PROFIT'}>}ACTUAL)

/

SUM(TOTAL {1<DESCRIPTION = {'GROSS_PREMIUM'}>}ACTUAL)

[sunny_talwar]

Not sure, but may be one of these

SUM({<DESCRIPTION={'CEDED_PREMIUM', 'NET_CLAIMS', 'COMM', 'EXPENSES', 'NET_PROFIT'}>} ACTUAL) /SUM({<DESCRIPTION = {'GROSS_PREMIUM'}>} ACTUAL)

or

SUM(TOTAL {<DESCRIPTION={'CEDED_PREMIUM', 'NET_CLAIMS', 'COMM', 'EXPENSES', 'NET_PROFIT'}>} ACTUAL) /SUM(TOTAL {<DESCRIPTION = {'GROSS_PREMIUM'}>} ACTUAL)

[settu_periasamy · Accepted solution]

Or

Just Sum..

SUM({<DESCRIPTION = {'CEDED','NET_CLAIMS','COMM','EXPENSES','NET_PROFIT'}>}ACTUAL)

Then,

Tick the "Relative" Option in Expression Tab

And Number Tab -> Fixed to - 2 -> Tick the Show in Percent(%)

Edit:

Like the Below screen shot?

[upaliwije]

Thanks all

But none of the options work

Only a single Bar Appears with 100% shown

[sunny_talwar]

I guess what I am confused about is that the values you have shown above are aggregated values or do they repeat over certain dimension or is that the only data within that table? I am having difficulty understanding the data model here. Would you be able to provide a sample or give some clarification?

[kaushiknsolanki]

Hi,

Find the attached result.

Regards,

Kaushik Solanki

[MK_QSL]

You have to use DESCRIPTION as dimension of bar chart

[upaliwije]

Your Chart is only a single bar and no % is for individually

What I want single horizontal bar representing  how GROSS PREMIUM is divided into following items

CEDED 21%   NET_CLAIM 40%  COMM 7%  EXPENSES 17% NET_PROFIT 16%

[kaushiknsolanki]

PFA