topic Re: Bar Chart in QlikView

Bar Chart

upaliwije — Mon, 07 Mar 2016 08:48:02 GMT

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)

Re: Bar Chart

MK_QSL — Mon, 07 Mar 2016 09:18:40 GMT

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

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

Re: Bar Chart

sunny_talwar — Mon, 07 Mar 2016 09:20:18 GMT

Not sure, but may be one of these

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

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

Re: Bar Chart

settu_periasamy — Mon, 07 Mar 2016 09:27:04 GMT

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?

Re: Bar Chart

upaliwije — Mon, 07 Mar 2016 09:37:20 GMT

Thanks all

But none of the options work

Only a single Bar Appears with 100% shown

Re: Bar Chart

sunny_talwar — Mon, 07 Mar 2016 09:40:35 GMT

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?

Re: Bar Chart

kaushiknsolanki — Mon, 07 Mar 2016 09:42:15 GMT

Hi,

Find the attached result.

Regards,

Kaushik Solanki

Re: Bar Chart

MK_QSL — Mon, 07 Mar 2016 09:51:43 GMT

You have to use DESCRIPTION as dimension of bar chart

Re: Bar Chart

upaliwije — Mon, 07 Mar 2016 09:53:15 GMT

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%

Re: Bar Chart

kaushiknsolanki — Mon, 07 Mar 2016 09:59:26 GMT

PFA