topic How to calculate Contribution in straight table? in QlikView

How to calculate Contribution in straight table?

Wed, 19 Aug 2015 07:53:45 GMT

Hello,

Can any one tell me how to calculate contribution in straight table.

Region	Mar-12 Sale	Contribution %
Total	2,403
E	1,312	54.6
U	730	30.4
SA	219	9.1
AF	21	0.9
AUS	60	2.5
LAT	50	2.1
ASIA	11	0.9
MIDDLE EAST	0	0.0

Here, i am using following expression for calculating Mar-12 sale

(SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

Thanks.....

Re: How to calculate Contribution in straight table?

Gysbert_Wassenaar — Wed, 19 Aug 2015 08:08:43 GMT

Try:

/100000)

(SUM(TOTAL {$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

Re: How to calculate Contribution in straight table?

vikasmahajan — Wed, 19 Aug 2015 08:14:47 GMT

You can also create Variable vSAL

vSAL = (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)

Contribution Column

((SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[PostDate]=">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Post Date]))"}>}[G_Amount]))

/100000)/vSAL)*100

HTH

Vikas

Re: How to calculate Contribution in straight table?

Wed, 19 Aug 2015 09:15:24 GMT

Thank you so much Gysbert & Vikas sir for the solution .....