topic Re: Issue in Onopen trigger in QlikView

Issue in Onopen trigger

Mon, 06 May 2013 10:33:33 GMT

Hi All,

I have written a macro which is used to exprot the chart and quit the application.

And Assigned this macro to onopentrigger, so that I am not able to open the application(When I open the qvw application, it is open and close immediately because of last statement of macro is quit application(qv.quit())

Please let me how can I open the application with out running that macro.

Thanks in advance.

Regards,

Kabilan K.

Re: Issue in Onopen trigger

er_mohit — Mon, 06 May 2013 10:46:15 GMT

here i used data to send in excel with using open trigger.

but it can't close the qvw file

match with your code

Sub Exceltest

'Set the path where the excel will be saved

filePath = "E:\Test.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set curWorkBook = excelFile.WorkBooks.Add

'Create the Sheet

Set curSheet = curWorkBook.WorkSheets(1)

'Get the chart we want to export

Set tableToExport = ActiveDocument.GetSheetObject("CH02")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

'Get the caption

chartCaption = tableToExport.GetCaption.Name.v

'MsgBox chartCaption

'Set the first cell with the caption

curSheet.Range("A1") = chartCaption

'Paste the rest of the chart

curSheet.Paste curSheet.Range("A2")

excelFile.Visible = true

XLApp.DisplayAlerts = False

'Save the file and quit excel

curWorkBook.SaveAs filePath

curWorkBook.Close

excelFile.Quit

'Cleanup

Set curWorkBook = nothing

Set excelFile = nothing

set XLApp = nothing

End Sub

Re: Issue in Onopen trigger

Mon, 06 May 2013 11:31:32 GMT

Hi,

I want to open the same application without running onopentrigger, which I am not able to open(because of open trigger and qv.quit()).

Regards,

Kabilan K.

Re: Issue in Onopen trigger

er_mohit — Mon, 06 May 2013 11:46:43 GMT

open another application and then

go to user prefrence-->Security--->uncheck the confirm launch from macro

then save it and open your application having macro

hope it helps

Re: Issue in Onopen trigger

suniljain — Mon, 06 May 2013 12:46:05 GMT

I have solution for this issue.

Step 1 :Open qlikview

Step 2 : In Getting Started , right click on your application and chose Open dashboard and realod data . pls change qvd name of any one QVD used by your dashboard.

Step 3: change your macro accordingly.

Regards;

Sunil