Download from table box, calculate in script & reload into chart
Hello,
I have a huge application where there are lot of calculations. To give an overview,
1. The table_box accepts some input value via input_box/input_field .
2. On clicking 'check' button, based on the values entered in the step1 lot of hierarchy checks are performed and error( if applicable) is produced in the 'error' chart below with corresponding error messages.
3. My table has nearly 75000 records, the 'check' button checks one record with every other 70000 record and displays the error message.
4. The 'check' button is taking nearly 30 minutes.
As I was not able to make a sample data qvw file, I will explain the data below in the image attached.
Note: We have already prepared the formula for the logics, the only problem is it is taking lot of time and I want to know
if there is an option where in i can first download the table_box data (with new values entered through input_fields/input_box). Then process the data in the script and then reload the data into the 'error' chart. By this way i avoid the aggr functions in the chart.
