Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

6 Replies
its_anandrjs

Hi,

Yes but help of macros.

Regards,

Anand

jagan
Luminary Alumni
Luminary Alumni

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.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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).

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

MarcoWedel

Link to the NPrinting / Excel Report website:

Export QlikView data to Excel without Macros - Vizubi: Office and HTML Report Creation and Distribut...

hope it helps

regards

Marco