topic Re: Applying pages to multiple excel tabs? in Qlik NPrinting

Applying pages to multiple excel tabs?

Anonymous — Mon, 17 Jul 2017 09:01:51 GMT

Hi people,

I'm in Nprinting 17.3 and am trying to set up a page to cycle through two tabs in excel by the same dimension with the goal of creating additional tabs split out by country.

Older versions allowed me to set up a page for each excel tab with the same dimension. The newer version won't allow for this and doesn't give an obvious option to apply the page to more than one tab like it does for Powerpoint.

Is anyone able to help? Thanks in advance!

Re: Applying pages to multiple excel tabs?

Mon, 17 Jul 2017 12:20:56 GMT

Chris,

Template editing is basically the same in NPrinting 16 and 17.

To add Page to a worksheet, just click on the worksheet and right click on page. You can do this for multiple worksheets. The dimension you use for Page can be the same or different for multiple worksheets.

Best

Aran

Re: Applying pages to multiple excel tabs?

Anonymous — Mon, 17 Jul 2017 13:06:39 GMT

Hi Aran,

I thought so too, but when I set up a page for two tabs with the same dimension and try to preview, i get the error: 'The preview request failed with message: Specified cast is not valid'.

Page split works if I apply it to one tab, but not two.

Any ideas?

Re: Applying pages to multiple excel tabs?

Mon, 17 Jul 2017 14:20:42 GMT

Try upgrading to the most recent release

Re: Applying pages to multiple excel tabs?

Anonymous — Mon, 17 Jul 2017 14:21:24 GMT

17.3

Re: Applying pages to multiple excel tabs?

Stephen_Jasionowski — Mon, 17 Jul 2017 15:36:33 GMT

This is a known bug that is not yet resolved in the most recent release (June 2017). Please check the release notes of any new versions or service releases as I do not have a date for resolution at the moment,

Re: Applying pages to multiple excel tabs?

Anonymous — Mon, 17 Jul 2017 15:48:03 GMT

Has there been any indication of when this will be fixed?

Re: Applying pages to multiple excel tabs?

Stephen_Jasionowski — Mon, 17 Jul 2017 17:16:38 GMT

I believe it will be fixed as part of the September 2017 release but we are still working out which bug fixes will be included. I will update the post as I know more.

Re: Applying pages to multiple excel tabs?

Lech_Miszkiewicz — Wed, 19 Jul 2017 02:20:58 GMT

I believe something else - If you apply the same field Paging onto Excel sheets essentialy you are creating 2 sheets with the same name in it - which is impossible in Excel.

You cannot have 2 Sheets names within WorkBook.

In your source document you can create 2 fields

say:

Country 1
Conutry 2

And you would have to adjust its values (by adding suffix/prefix or anything else) to ensure that they are distinct!.

regards

Lech

Re: Applying pages to multiple excel tabs?

Anonymous — Wed, 19 Jul 2017 14:25:39 GMT

Lech!!!! You bloomin' genius!

Re: Applying pages to multiple excel tabs?

Stephen_Jasionowski — Wed, 19 Jul 2017 15:44:09 GMT

Great insight, Lech.

Taking that a step further, if you didn't want to create a new field in the data model, you can also name the sheets differently in the Excel template(e.g. Sales for <Country> and Revenue for <Country>).

I would imagine that should get around the limitation that Lech noted.

Re: Applying pages to multiple excel tabs?

Wed, 19 Jul 2017 15:51:11 GMT

Actually you could get different values within the worksheet tab by just adding any character into the tab along with the NPrinting tag.

Something like:

<Country>.

and

This should work too without having to create an artificial dimension.

Re: Applying pages to multiple excel tabs?

Lech_Miszkiewicz — Wed, 19 Jul 2017 22:17:32 GMT

‌Hi Aran

before i wrote my previous suggestion i also thiught of your solution. However every time you try to alter a sheet name which is a part of a "paged"sheet then Nprinting Page Node disapears and is moved to LeLevels. Try it!

at the end it did not work. That is why i brought an idea of creating 2 source fields

cheers

LEch

Re: Applying pages to multiple excel tabs?

Lech_Miszkiewicz — Thu, 20 Jul 2017 03:15:01 GMT

Hi Stephen

I tried this before and it will not work - PageNode seems to be directly linked to Sheet Name. Any adjustments to it result in Page node disapering and moving to levels.

regards

Lech

Re: Applying pages to multiple excel tabs?

Ruggero_Piccoli — Mon, 24 Jul 2017 13:37:53 GMT

Hi,

Only in a PowerPoint template you can set the slides that would be affected by a field in the Pages node. This feature was never available also in older version, so for the solution in Excel refer to other suggestions 🙂

The feature is still available in PowerPoint templates:

Re: Applying pages to multiple excel tabs?

Anonymous — Mon, 24 Jul 2017 14:07:40 GMT

Hi Ruggero,

Read above. Another user already showed us how to do it in Excel....