Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.