Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro export excel - simulation break

Hi all,

I'm currently  implementing Macro module to realized a custom Excel export.

In details, we have a QlikView table where each element in the column A (we can call it father) can has, in the column B, one or more rows (we can call it children). After the export, if the table is too long to fit in an excel page, we should split the exceeded rows in an other page. Implementing this export,I want  to avoid to break the table splitting in two different page, children belong to the same father.

Do you know if is there any way/library/function to achieve my goal? Thank you!

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Isn't it easyer to install Excel 2010 in which there are more than 1 million rows?

If you need Greater pages then maybe Excel id not the best choose.

Let me know

Not applicable
Author

Hi,

the problem is not the limitation in the number of exported rows but how they are exported. Please see attached files that show the output result that I would need. Thank you.