topic Re: Pages Cycled in Multiple Sheets in excel in Qlik NPrinting

Pages Cycled in Multiple Sheets in excel

bharath28 — Mon, 29 Jan 2018 12:15:36 GMT

Hi Everyone,

In nprinting power point report we have Slides property to cycle on multiple slides. I am looking for similar option in Excel report in nprinting to cyclic on multple sheets. Unfortunately i couldn't find this property in excel report, please let me know if there is any alternate option, or if i missing something.

Please help!

Thanks!

Re: Pages Cycled in Multiple Sheets in excel

Ruggero_Piccoli — Mon, 29 Jan 2018 14:21:42 GMT

Hi,

No, in Excel templates there is not a similar property.

You need to add a Page on the first worksheet and then add a second Page (with the same QlikView or Qlik Sense field) in the second worksheet.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. 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.

Re: Pages Cycled in Multiple Sheets in excel

bharath28 — Mon, 29 Jan 2018 17:29:56 GMT

Hi Ruggero,

I tried your solution but gets below error when running the report.

Error: The same worksheet name already exists.

The sheet names are the names of the page fields that i have added twice and i see both the sheet names are different as shown below

<Field_Page>

<Field_Page_2>

Please help!

Re: Pages Cycled in Multiple Sheets in excel

Lech_Miszkiewicz — Mon, 29 Jan 2018 22:14:17 GMT

yes - this is expected

my solution is:

assume that you are cycling through field values in column called my_field
in Qlik Load script i modify this column by adding prefix or suffix like this:
- '1 '&my_field as my_field_1
- '2 '&my_field as my_field_2
then in NPrinting i use
- my_field_1 as a property for 1 page
- my_field_2 as a property for 2 page

This solution keeps all the sheet names unique and also provides logic for sheet names where i know which one is which one.

hope this helps

cheers

Lech

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

Re: Pages Cycled in Multiple Sheets in excel

Ruggero_Piccoli — Tue, 30 Jan 2018 09:27:51 GMT

Hi agree with Lech.

Another solution is to edit the worksheet names by adding a fixed string.

In this case you add the same field two times without the need of changing the script.

I forgot to mention this in my first answer, sorry.

Best Regards,

Ruggero

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

Re: Pages Cycled in Multiple Sheets in excel

bharath28 — Tue, 30 Jan 2018 12:24:00 GMT

‌Thanks both. It is working now.

one final query. This solution giving me a series of slides for field1 and then for field2 In page.

MY requirement is to keep both slides side by side for first value in field and then for second value.

is it possible to achieve this?

Thanks

Re: Pages Cycled in Multiple Sheets in excel

Ruggero_Piccoli — Tue, 30 Jan 2018 13:05:25 GMT

Unfortunatly it is not possible.

Qlik NPrinting will create first the first worksheet with all its copies, then the second, etc.

Re: Pages Cycled in Multiple Sheets in excel

bharath28 — Tue, 30 Jan 2018 13:27:04 GMT

‌thanks everyone for the help