Recursive calculation in script

[#1]

Hi,

Can anyone tell me how can i do it (following) in Qlikview? As per my finding it can not be done, if so what are the workarounds that anyone suggest?

Table-A

Row	E	F	G
1	0.0111	0.2222	0.1222
2	0.3333	0.4444	0.2322

Table-B

Row	A	B	C	D
1	100	A+(A*E)	B+(B*F)	C+(C*G)

Thanks and Regards

[stigchel]

Not sure what your real requirement is, but if you are worried about recursive calculations and looking for a way to perform them only once (instead of getting a lengthy formula for D, with calculations already done in C,B and A) ...

You can use preceding loads:

Table1:

LOAD Row,

     E,

     F,

     G

FROM

[https://community.qlik.com/thread/238928]

(html, codepage is 1252, embedded labels, table is @1);

Table2:

Load Row,A,B,C,D;

Load *, C+(C*G) as D;

Load *, B+(B*F) as C;

Load *, A+(A*E) as B;

Load *,100 As A Resident Table1;

[stigchel]

Qvw attached

[#4]

Thanks Piet for your reply.

Please refer to the snapshot pasted below:

Table A - from row 4-6 (few selected rows)

Table B - from row 50 - 53 (few selected rows)

I have approx 300 columns (date) which are dynamic and grows with time.

Now, the recursive calculation occurs in the second table starting from row 49. The calculation refers to data in table A than a cell value is calculated than that value is used in the next cell of table B which can be expressed like this for cell D and E in table B and carried forward in the same manner for the remaining columns:

Table B, Cell 😧     =C50+C50*D4

Table B, Cell E:     =D50+D50*E4 ...

I hope i've made myself clear; as you might note i have created a cross table of the above, so the date and sectors are rows.

[MarcoWedel]

please post some sample data as file not as screenshot to test with.

I guess you want to crosstable load your table at first instead of dealing with constantly growing column/field numbers?!?!

thanks

regards

Marco

[MarcoWedel]

Hi,

one example using your first table (Table-A):

TableA:
CrossTable(attribute, data)
LOAD Row,
    E,
    F,
    G
FROM [https://community.qlik.com/thread/238928] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco