topic Re: Export to Excel in QlikView

Export to Excel

soha1902 — Thu, 18 Dec 2014 07:10:28 GMT

Hi All,

I want to export pivot table to excel sheet with different formatting. QV pivot table is look like below image:

Desired output which I want in excel is look like below image:

I wrote macro to export chart to excel but not able to get the desired formatting.

Thanks.

Re: Export to Excel

amit_saini — Thu, 18 Dec 2014 07:14:44 GMT

Hi Soha,

Are u talking about date format while exporting.???

Thanks,
AS

Re: Export to Excel

soha1902 — Thu, 18 Dec 2014 07:29:15 GMT

Hi Amit,

When we clicked on Export to Excel button then I want excel sheet as per attached image (available in original post). (Font Size, background color, cell merging etc)

Thanks.

Re: Export to Excel

amit_saini — Thu, 18 Dec 2014 07:34:23 GMT

Soha ,

I don't think so it is possible .

Thanks,
AS