topic Re: Growth in QlikView

Growth

upaliwije — Thu, 21 May 2015 05:51:04 GMT

HI Friends

I have created the following Pivot table where Ach % and Growth % need to be calculated

my expression for calculation of Growth is as follows but the result is not calculated. Pls see whether there is any error in the expression

YEAR is a dimension field

(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]))"}>} [ACTUAL] )

-sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))

/Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))*100

Thu, 21 May 2015 06:05:06 GMT

Try like this for growth:

(((sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]))"}>} [ACTUAL] ))

/(Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))))-1)*100

If still not working can u share qvw for above.

Thanks

Khushboo

tresB — Thu, 21 May 2015 06:09:48 GMT

Is DESCRIPTION a field and 'GROSS_PREMIUM' is a field value to it? If so, put the string within single quotes like:

sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},..

Thu, 21 May 2015 06:11:20 GMT

Try this:

(sum(<{description= {gross_premium}, Year={"$(=Only([YEAR]))"} }> [Actual]) /

sum(<{description= {gross_premium}, Year={"$(=Only([YEAR]-1))"} }> [Actual]))-1

er_mohit — Thu, 21 May 2015 06:16:31 GMT

Try this

(sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},YEAR = {'=$(=max([YEAR]))'}>} [ACTUAL] )

-sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},YEAR = {'=$(=max([YEAR])-1)'}>} [ACTUAL] ))

Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {'=$(=max([YEAR])-1)'}>} [ACTUAL] ))*100

upaliwije — Thu, 21 May 2015 06:39:45 GMT

Now the output is like this

tresB — Thu, 21 May 2015 06:43:46 GMT

I guess you could help us help you by sharing your qvw with sample data.