topic Calculate value between two different charts in QlikView

Calculate value between two different charts

Thu, 17 Mar 2011 10:25:10 GMT

Hi there,

I currently have two table charts:

Table A

Indexed LTV Band	All loans
0%-60%	246832
100%+	11134
61%-65%	20394
66%-70%	21046
71%-75%	20831
76%-80%	21979
81%-85%	21755
86%-90%	19710
90%-95%	15197
96%-99%	8308
Total	407186

Table B

Indexed LTV Band	All loans
0%-60%	1569
100+%	2007
61%-65%	2193
66%-70%	2382
71%-75%	2600
76%-80%	2803
81%-85%	3038
86%-90%	3246
90%-95%	3413
96%-99%	3566
-	407186

I am trying to calculate between two charts to have value A - value B and give me Value C.

Indexed LTV Band	A	B	C
0%-60%	246832	1569	245263
100+%	11134	2007	9127
61%-65%	20394	2193	18201
66%-70%	21046	2382	18664
71%-75%	20831	2600	18231
76%-80%	21979	2803	19176
81%-85%	21755	3038	18717
86%-90%	19710	3246	16464
90%-95%	15197	3413	11784
96%-99%	8308	3566	4742

Not sure if Qlikview is able to do this?

Calculate value between two different charts

prieper — Thu, 17 Mar 2011 10:58:14 GMT

Join both tables on the field "Indexed ..." and then do your calculations.

Data: LOAD [Indexed LTV Band], A FROM ....;
JOIN LOAD [Indexed LTV Band], B FROM ....;
CombinedData: LOAD *, A-B AS C RESIDENT Data;
DROP TABLE Data;

you may also choose to only join the tables and do the calculation in your forms/graphs.

HTH
Peter

Calculate value between two different charts

Thu, 17 Mar 2011 11:26:56 GMT

Really sorry but I am really new to Qlikview and try to familarise with the functions that it has. How do you join those tables?

It is not going to be Edit Scripts and enter the information above?

Or should I be creating a new sheet object and add the information above?

Calculate value between two different charts

prieper — Thu, 17 Mar 2011 15:00:28 GMT

It is Edit Scripts, copy the above and finetune for your own data.

++
Peter

Calculate value between two different charts

Thu, 17 Mar 2011 15:57:27 GMT

Problem that I have is, I have already used the Edit Script to import some data from the source. From this script, I then split the data into Table A and B (mainly for different fitlers) using ranges and count. Now that I split them, I want to do such a way total in Table A - total in Table B and give me the balance for each index LTV.

Unless you are suggesting that I can do all these in one big Edit Script?