Need Help on a Macro to insert the data into database...?

[Anonymous]

Hi Experts..

for the first time we are using a macro  in Qlikview to insert the  resultant  data into Database (SQL)...and we don't know how it is going to effect on the performance of the application...

we want to insert these details into DB : Application Name , Date, Success rate, Over all status

Step 1  : we are Exporting the above mentioned 4 details  from dashboard to a .Qvo file.

Step 2 : we are running the macro to pick the values from the .qvo file and to insert them in the database table..

we are attaching the Macro we are using to achieve this...

issue : the main issue is when we use the exported file in macro it is not inserting the values in the DB , we tried with different formats like .txt , .qvo , .stv...

but when we copy the data from the exported file to another file and take that file in macro then it is successfully inserting the data...

Why that Exported file is not working in the macro , we need to any changes while exporting the data like file names or need changes in macro...

Please help us as we are new to these kind of requirements and Macros too...

thanks in advance..

Best Regards

Anusha.

[Anonymous]

I would suggest go with DynamicUpdate .

Re: Dynamic value update of the inputbox

Thanks

BKC