topic Re: Reuse a Calculation in a QVD Load in QlikView

Reuse a Calculation in a QVD Load

Wed, 14 Sep 2016 14:52:45 GMT

I have this hypothetical scenario:

LOAD

d * e / f + g - h as UglyCalculation,

from My.qvd (qvd);

I need to reuse UglyCalculation and would rather not repeat it everywhere. Is there a way to reference it by alias in further calculations in the same load? I need (for example)

UglyCalculation / x as x1,

UglyCalculation * y as y1,

I know that won't work, of course. Can it be managed somehow with a second LOAD statement?

Thanks.

Re: Reuse a Calculation in a QVD Load

sunny_talwar — Wed, 14 Sep 2016 14:54:42 GMT

May be check this out:

https://www.quickintelligence.co.uk/variables-parameters-load-script/

Re: Reuse a Calculation in a QVD Load

Clever_Anjos — Wed, 14 Sep 2016 14:54:55 GMT

Use preceding load

LOAD *,

UglyCalculation / x as x1,

UglyCalculation * y as y1;

LOAD

d * e / f + g - h as UglyCalculation,

from My.qvd (qvd);

Re: Reuse a Calculation in a QVD Load

Thu, 15 Sep 2016 13:39:43 GMT

Thank you. More to my issue at hand, I didn't realize you could "stack" preceding loads, which is exactly what I needed here. It's best not to get carried away, of course, but it's a perfect fit here. Thanks again.