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

Anonymous — Fri, 28 Aug 2015 05:58:18 GMT

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.

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

Anonymous — Fri, 28 Aug 2015 06:17:53 GMT

I would suggest go with DynamicUpdate .

Re: Dynamic value update of the inputbox

Thanks

BKC

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

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

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