Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Send to XL with formatting.

Hi,

My end users are expecting the report to be formatted when we click the send to xl button. Can anyone help me here?

Thanks

Venkatachalam.N

5 Replies
ecolomer
Master II
Master II

Can you explain problem a bit more,

TX

Not applicable
Author

Hi Enrique,

I have a straight table chart with 5 Dimensions and 10 Metrics in a specific format on Qlikview document. Users want to use the button send to XL in that straight table as they do so, they want the data to be exported with the page set up to be in a printable format.

Thanks

alkesh_sharma
Creator III
Creator III

Not Possible. Send to excel creates reports in default format.

I may be achieved using macros. but I am not sure.

MarcoWedel

Maybe generating Excel reports using NPrinting (third party reporting solution for QlikView) could be a solution for you:

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

Create_Excel_reports.png

Hope this helps

regards

Marco

amit_saini
Master III
Master III

Hi,

I would suggest two ways here:

  • Nprinting Tool
  • Second you do this by the help of macro and run that macro through export button.

Thanks,

AS