Enable cycle using Nprinting

[varunreddy]

Hi All,

I am trying to convert Crystal Reporting format from SAP to Qlikview. For this I am using Nprinting and using "Enable Cycle" option. This is creating 'n' separate excel files. My requirement is to consolidate all the individual files into one single file. Is there a way to do this?

Thanks in advance!

Cheers,

Varun

[Lech_Miszkiewicz · Accepted solution]

Hi Varun - yes there is.

you will not use cycle feature, but instead within excel template you can use Page or Level feature.

read more here:

https://help.qlik.com/en-US/nprinting/April2018/Content/ExcelReports/More-Levels-Excel-Reports.htm‌

https://help.qlik.com/en-US/nprinting/April2018/Content/ExcelReports/NPrinting-Features-Excel.htm

Creating Excel reports with levels and subtotals in Qlik NPrinting - Qlik Tuesday Tips and Tricks - ...‌

note: make sure that field values you will be using in level or page can be a sheet name and will not have duplicates.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[varunreddy]

Hi Lech,

Thank you very much for your response!

Cheers

Varun