topic vbscript help in QlikView

vbscript help

Wed, 07 Mar 2012 13:52:31 GMT

Hi everyone I have problem in qlikview with vbscript. I try to find a way to do 2 things

1: I have a database connected to qvw. I want to create a macro that deletes from qvw a record which no more exists in my database and

2: I want to insert a record which exists in my database but not in qvw.

I don't want to make a reload

Could anyone help me. I could not figure this out only update qlikview from db I have done.

Pleaseeeeeeeeeeeeeeeee

vbscript help

jagan — Wed, 07 Mar 2012 14:01:38 GMT

Hi,

Without reload you cannot update the data in the qlikview file. But instead of reloading using the reload button, you can reload it by using a macro if needed.

Without reloading you cannot add/delete the data from qlikview file.

Regards,

Jagan.

vbscript help

Anonymous — Wed, 07 Mar 2012 14:04:57 GMT

sub autoreload

activeDocument.reload

end sub

Using the above macro you can reload the qlikview on any event / triggers ( onOpen , button click...)

Regards

Ashok