topic Re: How to get percentage Difference in QlikView

How to get percentage Difference

Mon, 25 May 2015 10:28:18 GMT

hi Everyone. i nee one help.. i calculate a Difference Between Current Year Sale and Last Year

like..

=if(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) > sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount))..

so i m getting and answer Suppose.. This Year sale is 100 Rs and Last Year sale was 50 Rs.. so total growth 50 Rs.. But i want

to show growth in %.. in this case my Revenue growth is 50 %.. because it got double from last year..

Plz help me how to do this

Re: How to get percentage Difference

MayilVahanan — Mon, 25 May 2015 10:36:34 GMT

Try like this

=if(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) > sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)) / sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount),

(sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount)) / sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)

)

Number tab, please check "Show in Percent"

Re: How to get percentage Difference

marcus_sommer — Mon, 25 May 2015 10:41:54 GMT

I would use something like this (simplified without conditions):

sum(CurrentYear) / sum(LastYear)

maybe extended to a 1 - Expressions or reversed or wrapped within a fabs() to display the result from a certain direction.

- Marcus

Re: How to get percentage Difference

Mon, 25 May 2015 10:53:41 GMT

hi Marcus,

on selecting any year ... its need to give current year sale and last year sale and Difference between and Percent Difference between them... can u able to send me the complete expression.. how to write,,..

Re: How to get percentage Difference

CELAMBARASAN — Mon, 25 May 2015 11:08:27 GMT

Actually formula for growth percentage is

((Current Value - Old Value)/Old Value) * 100

So your expression would be

=((sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year ={$(=max(Year)-1)}>}Price_Pcs_Incl_Discount))/ sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)) * 100