Download from table box, calculate in script & reload into chart

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Download from table box, calculate in script & reload into chart

marcus_sommer — Thu, 25 Aug 2016 08:16:40 GMT

What do you are want to do is a quite complex process especially by using input-fields. Maybe this: Write back to database via XML output or web service or this: SQL Writeback from QlikView extension object. will be helpful for you.

- Marcus

topic Re: Download from table box, calculate in script & reload into chart in QlikView

Download from table box, calculate in script & reload into chart

Re: Download from table box, calculate in script & reload into chart