topic Resolve formula in script in QlikView

Resolve formula in script

Fri, 27 Nov 2009 18:16:48 GMT

Hi all...

I have a XLS with Formula, like this:

Code Formula
A A1 + A2
B B1 + B2
Z A + B

How do I resolve Z?
After the load-script I want to have a table with the following result:

Code Formula
A A1 + A2
B B1 + B2
Z A1 + A2 + B1 + B2

Maybe someone could help me?

Thanks a lot
Ivo

Resolve formula in script

Fri, 27 Nov 2009 19:57:16 GMT

Hi,

try to use MapSubstring function. Here is an example how to write a load script:

map_table:

MAPPING LOAD

Resolve formula in script

Fri, 27 Nov 2009 20:01:31 GMT

map_table:

MAPPING

LOAD

code

formula

FROM ....

xls;

Formulas:

load

code,

(code='Z',mapsubstring('map_table',formula),formula) as formul

FROM ..

.xls;

I hope this will help you.

Regards,

Milda

AW:Re: Resolve formula in script

Fri, 27 Nov 2009 21:37:25 GMT

Hi Milda.

Yes this works fine!

Now I would create me a loop, because I have an undefined number (max.5) of nested levels like this:

code, formula
$A, 'A1, A2'
$B, 'B1, B2'
$Z, '$A, $B'
$ZZ, '$Z, C1, C2'

Thank you very much!
Nice weekend.

Best Regards.