topic Re: Error Handling for obj.export in QlikView

Error Handling for obj.export

Anonymous — Tue, 19 Jan 2016 19:03:33 GMT

I am trying to write a macro in qlikview for exporting a chart to csv. If the file does not exist, I get an error "Cannot open file test.csv for writing"

I would like to have a different message box appear if this happens. I tried adding On Error Resume Next and added

If err <> 0 Then

Msgbox("Test")

End If

But the message box does not pop up, and I continue to receive the error message for exporting. How do I get the Msgbox to show?

Thanks in advanced!

Re: Error Handling for obj.export

Oleg_Troyansky — Tue, 19 Jan 2016 19:29:31 GMT

Try this:

If Err.Number <> 0 Then

...

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

Re: Error Handling for obj.export

Anonymous — Tue, 19 Jan 2016 19:32:55 GMT

Still no luck.