topic Re: Export To Excel in QlikView

Export To Excel

Mon, 02 Feb 2015 06:19:50 GMT

Hi All,

I have created a dashboard , In which there is a pivot table which has the entries related to the business

, I need to import the values to the excel sheet for which i am running the macro ,

But it is not working , i don't know how do we run it ,. i am attaching the file for ur reference , I hope i will get the solution

Thanks in Advance.

Re: Export To Excel

Mon, 02 Feb 2015 07:15:02 GMT

Hi Wrestler,

Can you try with below changes in Macro editor.

If you want to export data into Excel you can click on 'XL' button top of chart.

Thanks,

Vamsi

Re: Export To Excel

Mon, 02 Feb 2015 07:27:36 GMT

Hi Wrestler,

I changed code in Macro, Now it's working. Please check and reply

PFA.

Thanks,

Chiru

Re: Export To Excel

arulsettu — Mon, 02 Feb 2015 07:31:22 GMT

check this macro

Useful Qlikview Macros

Re: Export To Excel

Anonymous — Mon, 02 Feb 2015 11:01:42 GMT

Hi,

Why you want to use Macro for exporting data to excel when u have a direct option to do so?

Laxmi

Re: Export To Excel

Mon, 02 Feb 2015 12:14:18 GMT

Actaully what i need is i want indivisual excel sheets for each region thats why iam using this macro. Yes i know that we have direct option of exporting to excel , but when we directly export to excel it will load all the pivot data , this i dont want , I want seprate excel sheets to be loaded for each of the region , thus trying the external macro .

From: Laxmi Kuber <qcwebmaster@qlikview.com>

To: the wrestler <zarrar_smile@yahoo.com>

Sent: Monday, February 2, 2015 4:31 PM

Subject: Re: - Export To Excel

Export To Excel

reply from Laxmi Kuber in New to QlikView - View the full discussionHi, Why you want to use Macro for exporting data to excel when u have a direct option to do so? Laxmi

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community