Total and SubTotal calculation

Karim_Khan — Mon, 24 Aug 2015 15:57:46 GMT

Hi Team,

I wanted to show the Total of the current [Sales Level 1 ] and at the end it should show the sum of All [Sales Level 1].

I will pass the selection on [Sales Level 2].Am able to calculate the first two field.But I am unable to get the %.

As per above Table am able to calculate Customer Count and Bookings.Now I want % Bookings which should show correctly as per

Calculation.

Bookings=Total/Sales Level 2

But its capturing only CANADA value in all Field which is wrong.I want the correct % Bookings value for remaining sales Level 2 also.

E.g :

If I select [Sales Level 1 ] AMERICAS.Then it should show the calculated % bookings value for [Sales Level 2 ] in the above table.

Expression for % Bookings as follow

=sum({$<[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 1]=, [Sales Level 2]={$(vSel2)}>} [Net Bookings])/sum({$<[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 2]=, [Sales Level 1]={$(vSel1)}>} [Net Bookings])

Regards,

MRKachhiaIMP‌jagan‌Kush141087‌gwassenaar‌

Re: Total and SubTotal calculation

settu_periasamy — Mon, 24 Aug 2015 17:21:24 GMT

Hi Karim,

Can you give the expected output for the above selection?

Re: Total and SubTotal calculation

Karim_Khan — Tue, 25 Aug 2015 10:37:07 GMT

HI Settu,

PFB

Sales Level 2	Customer Count	Bookings	% Bookings
	6958	222457000.8	100%
CANADA	631	20932019.92	9.41%
LATIN AMERICA	741	29788670.25	13.39%
US COMMERCIAL	4098	58816212.46	26.44%
US ENTERPRISE	549	51737137	23.26%
US OTHER	3	5475872.92	2.46%
US PS MARKET SEGMENT	1402	55707088.24	25.04%

topic Re: Total and SubTotal calculation in QlikView

Total and SubTotal calculation

Re: Total and SubTotal calculation

Re: Total and SubTotal calculation