Dynamic update of the source file with the Expression values calculated in the chart table

santhosh_k_n — Sat, 23 Aug 2014 10:37:36 GMT

Hi All,

I had a requirement to update my QVd data with the calculation made on the chart for the same data.

for example: Consider the following data which is available for Day1

Day1
Name	address	EXP field 1	EXP field 2	EXP field 3
A	address1	20	23	43
B	address2	23	44	67
C	address3	11	54	65
D	address4	34	64	98

where Exp field1 is a one time data entry into the Qvd and Exp field3 is a calculation made based on Exp field1 and exp field 2.

And day2 the Exp field 3 data on day 1 should be the Exp field data 1 for Day 2 as shown below ,

Day2
Name	address	EXP field 1	EXP field 2	EXP field 3
A	address1	43	34	77
B	address2	67	23	90
C	address3	65	43	108
D	address4	98	12	110

Similarly need to proceed for day 3..

Day 3
Name	address	EXP field 1	EXP field 2	EXP field 3
A	address1	77	212	289
B	address2	90	45	135
C	address3	108	55	163
D	address4	110	123	233

And adding to that we will be providing the date filter for this and based on the data selected the data for previous day in exp field 3 should be available as data for Exp field 1.

Please guide me to achieve the same.

Thanks in advance.

BR,

Santhosh

topic Dynamic update of the source file with the Expression values calculated in the chart table in QlikView

Dynamic update of the source file with the Expression values calculated in the chart table