Export To Excel

[#1]

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.

[#2]

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

[#3]

Hi Wrestler,

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

PFA.

Thanks,

Chiru

[arulsettu]

hi

check this macro

Useful Qlikview Macros

[Anonymous]

Hi,

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

Laxmi

[#6]

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

© 1993-2014 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA