topic Re: Issue with Export to Excel in QlikView

Issue with Export to Excel

riyazasma1009 — Mon, 21 Dec 2015 09:27:57 GMT

Hi All,

I have a pivot table as shown in the attachment. When I export this table to excel, the first row in which columns are merged together, does not come in the expected format in the exported excel.

Can someone please help me with this?

Thanks,

Asma

Re: Issue with Export to Excel

alexandros17 — Mon, 21 Dec 2015 09:32:59 GMT

If you are using plugin try to install it again, it is not a Qlik problem but an excel or browser problem so take a look to these app. settings

Re: Issue with Export to Excel

riyazasma1009 — Mon, 21 Dec 2015 09:34:41 GMT

Hi Alessandro,

Thanks for your quick reply!!

I am trying to export it to excel from my local QV Desktop itself. I am not opening it through browser.

Could you please let me know if there any settings that need to be done either in excel or in Qlikview to get the table exported in the same format.

Thanks,

Asma

Re: Issue with Export to Excel

Mark_Little — Mon, 21 Dec 2015 09:42:38 GMT

Hi,

Can you give a little more information. What exactly is the problem that you're seeing?

Mark

Re: Issue with Export to Excel

riyazasma1009 — Mon, 21 Dec 2015 09:46:49 GMT

Hi Mark,

The table as present in Qlikview is as shown below:

After exporting to excel, it gets exported in the below format:

The merging of columns is lost.

Could you please let me know if I have missed out any settings that need to be done.

Thanks,

Asma

Re: Issue with Export to Excel

settu_periasamy — Mon, 21 Dec 2015 09:54:11 GMT

Hi,

If it is small table / Summary, Just Copy To ClipBoard -> FULL Table, And paste it in your excel. You will get the exact format.

Re: Issue with Export to Excel

Mark_Little — Mon, 21 Dec 2015 09:55:50 GMT

Hi,

I am sorry i am not sure you can change it,I am having a play now.

I get the same problem when exporting a pivot table, i think this is just the way it passes of the data to excel.

Mark

Re: Issue with Export to Excel

riyazasma1009 — Mon, 21 Dec 2015 09:57:52 GMT

Hi,

After copying the data to clipboard and then pasting it in excel, works fine. But we want this sort of functionality to be achieved by using the in-built Export to Excel option. Users are mainly interested in exporting it using the export to excel icon and they want the same structure to be exported in excel as in exists in QV.

Is it possible in QV or is there any workaround for the same.

Thanks,

Asma

Re: Issue with Export to Excel

riyazasma1009 — Mon, 21 Dec 2015 09:58:55 GMT

Hi Mark,

Thanks for the reply!

Is there any workaround available for the same.

Thanks,

Asma

Re: Issue with Export to Excel

PradeepReddy — Mon, 21 Dec 2015 10:12:52 GMT

try this macro, under button actions... Replace the object names with desired....

Merging cells while exporting to excel

sub xport2xl()

iRow = 1

set xlApp = CreateObject("Excel.Application")

xlApp.Visible = True

set xlWB = xlApp.Workbooks.Add

set xlSheet = xlWB.Worksheets(1)

set obj = ActiveDocument.getsheetobject(ChartName)

xlSheet.Activate

xlSheet.Cells.Clear

set txt = ActiveDocument.GetSheetObject("CH132")

txt.CopytableToClipboard TRUE

xlSheet.Cells(iRow,1).Select

xlSheet.Paste

while not (isempty(xlSheet.Cells(iRow,1)))

iRow = iRow+2

wend

set txt1 = ActiveDocument.GetSheetObject("CH132")

txt1.CopytableToClipboard TRUE

xlSheet.Cells(iRow,1).Select

xlSheet.Paste

end sub

Re: Issue with Export to Excel

settu_periasamy — Mon, 21 Dec 2015 10:17:39 GMT

May be Macro..

Same Formating of qlikview pivot table in Excel