topic Re: Recursive calculation in script in QlikView

Recursive calculation in script

Mon, 07 Nov 2016 17:20:51 GMT

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

Re: Recursive calculation in script

stigchel — Mon, 07 Nov 2016 17:40:58 GMT

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,

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;

Re: Recursive calculation in script

stigchel — Mon, 07 Nov 2016 17:42:12 GMT

Qvw attached

Re: Recursive calculation in script

Mon, 07 Nov 2016 18:08:24 GMT

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.

Re: Recursive calculation in script

MarcoWedel — Mon, 07 Nov 2016 21:54:33 GMT

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

Re: Recursive calculation in script

MarcoWedel — Tue, 08 Nov 2016 21:02:03 GMT

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