topic Re: Export to Exccel issue in QlikView

Export to Exccel issue

svsudhakar — Wed, 19 Mar 2014 04:58:07 GMT

Hi ,

some times I am facing issue with Export to excel option.

No response even we export, send to excel or
clicking the excel icon on straight table or pivot table.

please help on this daily I am facing this issue.

Thanks in Advance..

Re: Export to Exccel issue

Anonymous — Wed, 19 Mar 2014 05:04:52 GMT

This might be due to some connecton problem or probably the data you are trying to export is beyong limits of Ecxel file ie, appr of 65000 rows.........

Please look at this side also...

Re: Export to Exccel issue

svsudhakar — Wed, 19 Mar 2014 05:08:08 GMT

I am trying to export below 2k records.

The problem is different users are facing this issue with different times.

Re: Export to Exccel issue

amit_saini — Wed, 19 Mar 2014 05:08:47 GMT

Hi Sudhakar,

I will suggest you to create a export button for your straight table or pivot table through a macro.

Sub ExportExcel1

vFile = ActiveDocument.Variables("vInput1").GetContent.String

'XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"

set obj = ActiveDocument.GetSheetObject("Give youe cahrt object ID here")

obj.ExportEx "Give path where you want to see the export result\"& vFile &".xls",5

End sub

Here create a variable by the name of vInput1 and give it value =test (the output of export to the given location will be test.xls)

Thanks,

Re: Export to Exccel issue

svsudhakar — Wed, 19 Mar 2014 05:23:45 GMT

Thanks for your suggestion AS.

Already dashboard is in live, if I create the macros through button again I have to give training to all users.

its difficult to manage. please suggest the any alternate solution.

regards,

SVS