topic Re: Export data from chart to excel using button in QlikView

Export data from chart to excel using button

Mon, 16 Mar 2015 08:56:51 GMT

Hi,

I have a straight chart, I want to export the data from chart to excel sheet using button object. how can I do that?

Re: Export data from chart to excel using button

Gysbert_Wassenaar — Mon, 16 Mar 2015 09:07:51 GMT

Don't. Enable the Send to Excel option on the Caption tab of the chart. Users can then click on the XL icon to send the chart to excel. No button needed.

Re: Export data from chart to excel using button

svsudhakar — Mon, 16 Mar 2015 09:11:44 GMT

hi sowmya,

If you want to export through button you need to write the Macro/Script.

Please find the below thread ..

http://community.qlik.com/message/418343#418343

Re: Export data from chart to excel using button

Mon, 16 Mar 2015 09:44:24 GMT

Hi Sowmya

Check this Screenshot below

Click This Button for Export data from chart to excel

Thanks & Regards

Naveen

Re: Export data from chart to excel using button

Wed, 10 Jun 2015 09:38:53 GMT

Maybe a stupid question but...

As the "action" exists, why we cannot directly use it in a button ?

I know we have different opinions about the utility of it but, if we want to do a selection before the "send to Excel", the user have to click on two different buttons potentially in two different places. (Without speaking about the discretion of this special icon.)

We can write a macro, but why reinvent the wheel? The action exists and runs well, why don't permit to use it in a button?

The same for the export, it exists in button's actions, but not for excel file.

Why this difference?

Sorry to reopen the topic with this question, but you seem to be aware and open to the discussion. Everywhere I see different macro to do the same thing and I don't understand why qlik doesn't yet offer this possibility.

Thanks to your reply.