topic Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense? in QlikView

Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

Sat, 22 Nov 2014 04:50:38 GMT

We are new customer to Qlik. is it above is possible? Please help us.

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

its_anandrjs — Sat, 22 Nov 2014 07:17:17 GMT

Hi,

Yes but help of macros.

Regards,

Anand

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

jagan — Sat, 22 Nov 2014 07:32:34 GMT

Hi,

Yes you can do it with the help of macros, check for sample macros in below link

Useful Qlikview Macros

Hope this helps you.

Regards,

Jagan.

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

stevedark — Sat, 22 Nov 2014 12:33:48 GMT

To do this you need to use a tool like NPrinting. With this you can build a template in Excel and place data and images directly into your Excel template automatically.

There is more information on NPrinting on our website here:

www.quickintelligence.co.uk/nprinting

Steve

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

Sat, 22 Nov 2014 17:16:20 GMT

Thank you. Wonderful information for new starters like us. BTW is it possible to do ‘Reload or Refresh’ dashboard via these macros? (I did see an example in your list). We hosted few reports in ‘Qlik View server’ for users. In general these reports refresh once in month automatically in server via scheduler. The requirement is to “allow these reports to refresh/get data directly from server” based on user request (instead of waiting on end of the month).

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

stevedark — Sat, 22 Nov 2014 21:35:15 GMT

Typically you can have refreshes much more frequent - particularly if you

have a robust incremental load strategy.

To allow user triggered reloads you should look at using EDX to fire

reloads. Once you have these you can use a simple script or batch file to

trigger reloads. If you want to trigger from inside a QlikView app you can

either have a link in the app to a web hosted script (eg. ASP.net) or code

something in an extension.

Macros can do reloads, but are not always reliable on the server.

Steve

Re: Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

MarcoWedel — Sat, 22 Nov 2014 23:57:56 GMT

Link to the NPrinting / Excel Report website:

Export QlikView data to Excel without Macros - Vizubi: Office and HTML Report Creation and Distribution Software

hope it helps

regards

Marco