topic Re: Dashboard exportation in QlikView

Dashboard exportation

Mon, 14 Jul 2014 08:55:21 GMT

Hi All,

Does anyone know if there is an option to export all the object in a specific sheet to excel together?

Thanks!

Re: Dashboard exportation

amit_saini — Mon, 14 Jul 2014 08:58:13 GMT

Michal,

Go to Settings-> User Preferences-> Export

Thanks,

Re: Dashboard exportation

Mon, 14 Jul 2014 08:58:46 GMT

I'm taking about ajax client..

Re: Dashboard exportation

ashfaq_haseeb — Mon, 14 Jul 2014 09:04:14 GMT

Hi,

I don't think so.

Will snapshot of a sheet fine for you?

Regards

ASHFAQ

Re: Dashboard exportation

Mon, 14 Jul 2014 09:04:54 GMT

Hi Amit! thanks..

please find attached.. in which QV version you are using? we are using 11.20 SR7..

Re: Dashboard exportation

amit_saini — Mon, 14 Jul 2014 09:04:54 GMT

Michal,

Macro can help here:

sub ExportWithSelections
      Set XLApp = CreateObject("Excel.Application")
      XLApp.Visible = True
      Set XLWorkbook = XLApp.Workbooks.Add
      Set XLSheet = XLWorkbook.sheets("Sheet1")
      XLSheet.Range("A3").Select

rem ** copy full chart details to clipboard **
ActiveDocument.GetSheetObject("CH252").CopyTableToClipboard false
XLSheet.Paste ' -4163 'values

XLSheet.Range("J2").Select

rem ** put current selection in J2 **
      ActiveDocument.GetSheetObject("CS12").CopyTableToClipboard true
      XLSheet.Paste ' -4163    'values
      XLApp.Selection.WrapText = False

      set XLSheet = nothing
      set XLWorkbook = nothing
      set XLApp = nothing

end sub

Note: You need to change the "CH252" to the object ID for the chart you want to export

Thanks,

Re: Dashboard exportation

ashfaq_haseeb — Mon, 14 Jul 2014 09:14:54 GMT

Hi,

Macro will not work in AJAX.

Regards

ASHFAQ

Re: Dashboard exportation

amit_saini — Mon, 14 Jul 2014 09:17:59 GMT

Right Sir

Re: Dashboard exportation

Mon, 14 Jul 2014 09:19:30 GMT

what do you mean by snapshot? is there an option to crate a button that does that?

Re: Dashboard exportation

amit_saini — Mon, 14 Jul 2014 09:20:34 GMT

Michal,

I'm using this in 11.20 SR2

Thanks,
AS

Re: Dashboard exportation

ashfaq_haseeb — Mon, 14 Jul 2014 09:32:49 GMT

Hi,

There is an extension. By which you can take snapshot of entire sheet and save locally in jpg.

If you are interested let me know.

Regards

ASHFAQ

Re: Dashboard exportation

Mon, 14 Jul 2014 09:46:05 GMT

Can you please send me more information about the extension?

Re: Re: Dashboard exportation

ashfaq_haseeb — Mon, 14 Jul 2014 09:49:25 GMT

Hi,

Look at the attached extension.

Regards

ASHFAQ