Dynamic update of the source file with the Expression values calculated in the chart table
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.
