topic Button with only Export Action in QlikView

Button with only Export Action

bimartingo — Fri, 17 Feb 2012 16:54:56 GMT

Hi,

i'm trying to use a button with the Action Export, but it's disabled (does not work) when it's the only action in the button. But i only want Qlikview to export the selected data to a delimited or csv text file, no other action.

Any alternative?

Button with only Export Action

Anonymous — Fri, 17 Feb 2012 17:48:50 GMT

I recall having this issue too... Not fixed yet?

My workaround was to add some harmless action, probably clear a field that's never selected, or something like that.

Button with only Export Action

Anonymous — Fri, 17 Feb 2012 20:20:29 GMT

Please confirm whether your macro sub function name (ie Sub ExportMacro()) and the your export button Run macro name both are same.

Regards

Ashok

Button with only Export Action

Anonymous — Fri, 17 Feb 2012 23:50:27 GMT

Looks like the question is about the Action Export, not an action that runs macro for export.

(At least this was my case.)

Button with only Export Action

bimartingo — Sun, 19 Feb 2012 13:25:03 GMT

Mr Solomovich is right. It's about the Action Export.

Of course, design a macro and assign the button to run the macro is a workaround, but i'm the oppinion macros should be used in exceptional situations, when there is no predefined action, or in very particular cases.

Button with only Export Action

Sun, 19 Feb 2012 18:55:21 GMT

Hi,

Export action should work even when used as only action, or atleast it is working for me.

I checked for both the 11 IR and 10 SR3.

I would suggest that you please check if you are setting up it properly.

May be you can try by checking 1st to set export to clipboard then you will get to know, if values are being pushed by Qlikview.

let me know, if I can be of help.

...

Thanks

Ashutosh

Re: Button with only Export Action

ThornOfCrowns — Thu, 19 Jun 2014 08:21:42 GMT

I added a button and set the Export action to it. Works fine with my version of Qlikview (10.00.9731.9 SR6 64Bit Edition).

Could you post a screenshot of your settings for the Export?

Re: Button with only Export Action

Thu, 19 Jun 2014 09:38:15 GMT

Hi James,

I just want make a button which has drop-down list to choose different format to export.

Please refer to word document to get some detail.

Re: Button with only Export Action

ThornOfCrowns — Thu, 19 Jun 2014 09:42:02 GMT

Helen, that's a different question than simply adding an Export button. You'd probably need to make a separate list box then pass the result of that to a Macro, rather than a button action.

Re: Button with only Export Action

Thu, 19 Jun 2014 09:56:22 GMT

Thanks James,

But could you please send me your script about the export action.

Re: Button with only Export Action

Wed, 19 Nov 2014 15:43:09 GMT

I had a button with an Export Action that was disabled. Turned out it was because I hadn't selected "Multi Value (*)" in the Export Lines.

Re: Button with only Export Action

Thu, 04 Dec 2014 17:43:37 GMT

You have to create a Macro and in the button object add action to call the macro name.

this example export object to excel. see

Sub Test

ExcelAppend "C:\QlikView\Ventas\test.xls", "CH02"

End Sub

Sub ExcelAppend(strExcelAppenFile, strExelAppendObjectID)

' Create an instance of Excel

SET objExcelApp = CREATEOBJECT("Excel.Application")

' Open workbook

' WITH objExcelApp

' .DefaultSaveFormat = xlWorkbookNormal

' .DisplayAlerts = FALSE

' .Workbooks.Open strExcelAppenFile

' .DisplayFullScreen = FALSE

' .Visible = FALSE

' END WITH

objExcelApp.DefaultSaveFormat = xlWorkbookNormal

msgbox(strExcelAppenFile)

objExcelApp.Workbooks.Open strExcelAppenFile

' set xlDoc =objExcelApp.Workbooks.Add

msgbox(strExcelAppenFile)

' Set worksheet

SET objExcelSheet = objExcelApp.Worksheets(1)

' Set Excel used range

SET objExcelRange = objExcelSheet.Range("A65535").End(-4162)

' Last used row in column A

intExcelLastRow = objExcelRange.Row

' Set object to append from

SET objObjectFrom = ActiveDocument.GetSheetObject(strExelAppendObjectID)

' Loop all rows of the object except first header row

Msgbox("Total rows = " & objObjectFrom.GetRowCount)

sheetNumber = 1

rowNumber = 1

FOR intObjectRow = 1 To objObjectFrom.GetRowCount - 1

msgbox(intObjectRow)

if intObjectRow Mod 5 = 0 then

rowNumber = 1

msgbox("Next sheet")

sheetNumber = sheetNumber + 1

msgbox(sheetNumber)

SET objExcelSheet = objExcelApp.Worksheets.Add

' Set Excel used range

SET objExcelRange = objExcelSheet.Range("A65535").End(-4162)

' Last used row in column A

intExcelLastRow = objExcelRange.Row

end if

' Loop all columns of the object

FOR intObjectColumn = 0 To objObjectFrom.GetColumnCount - 1

' Get object data

SET objCell = objObjectFrom.GetCell(intObjectRow, intObjectColumn)

' Add that data to Excel cell

objExcelSheet.Cells(rowNumber + intExcelLastRow, intObjectColumn + 1) = objCell.Text

rowNumber = rowNumber + 1

' Save and quit

objExcelSheet.SaveAs strExcelAppenFile

objExcelApp.Application.Quit

SET objExcelSheet = NOTHING

SET objExcelApp = NOTHING

END SUB

when you create this macro, add a button object to the QV document and in de actions tab add action in RunMacro option. then call the de macro name in this action.

I hope help you.

Re: Button with only Export Action

Anonymous — Thu, 04 Dec 2014 18:32:43 GMT

Use Macro