topic Re: Request for an answer in QlikView

Request for an answer

nevilledhamsiri — Mon, 14 Aug 2017 16:48:05 GMT

Hi,

As per the data loaded, once the growth rate was computed, the results generated are in order except the growth rate on MR & TT classes.The issue here is as we generally encounter even in Excel where the growth rate becomes negative even if the current Year figure looks positive over a negative figure in the corresponding last Year. Look forward for a remedy to overcome this. As can be seen below, said two classes have taken a negative growth rate which of course to be positive. How this could be tackled in qlik view.

Neville.

Re: Request for an answer

felipedl — Mon, 14 Aug 2017 19:52:34 GMT

Hi Neville,

See if this suits you.

Sample:

LOAD * Inline

[

BR_CODE,CLASS,CY,LY

RA,FR,30,25

RA,HH,30,20

RA,M3,25,50

RA,M4,100,75

RA,MC,125,125

RA,MR,5,-2.5

RA,MS,25,35

RA,PP,25,20

RA,TC,35,25

RA,TT,15,-5

RA,MM,-5,10

RA,PN,-5,-10

];

Data:

Load

if (CY > LY, fabs(Growth),Growth) as RealGrowth;

Load

(1 - CY/LY) as Growth

Resident Sample;

drop table Sample;

This gives me the bellow image

Re: Request for an answer

nevilledhamsiri — Tue, 15 Aug 2017 00:24:23 GMT

Dear Felip,

Is there other way forward?. You mean to load inline with resulted figures? such as growth rate received in data load as it is. Could you please suggest a formula in expression?. Can this formula be applied in expression?

Neville

Re: Request for an answer

Anil_Babu_Samineni — Tue, 15 Aug 2017 00:27:08 GMT

May be number format for 3rd expression like (#,#00);(#,##0)

Re: Request for an answer

nevilledhamsiri — Tue, 15 Aug 2017 15:43:56 GMT

Dear Felip, Your expression as suggested below did work, Thanks a lot. I simply applied it as an expression in the Pivot table which produced the results I expected.

if (CY > LY, fabs(Growth),Growth)

Neville

Re: Request for an answer

felipedl — Wed, 16 Aug 2017 13:33:28 GMT

Good to hear it helped Neville ,

Can you mark the correct answer please.

Thanks

Re: Request for an answer

nevilledhamsiri — Wed, 16 Aug 2017 17:02:49 GMT

if (CY > LY, fabs(Growth),Growth)

I managed to get my results by applying the above formula.

Thanks

Neville