Formula in Excel Sheet Names?

[Danijel]

Hello togehter,

I created a formula within the NPrinting Designer (NP June 2019). I would like this to be displayed inside the sheet and in the sheet name.

In the cell the correct value is displayed, within the name the formula is not resolved.

Enclosed is a screenshot for clarification.

I'am doing something wrong, bug or feature?

Thanks and greetings

[Lech_Miszkiewicz]

Hi,

This is not a bug. This is working as designed.

So the only way of having dynamic Sheet names in excel templates is by using PAGE nodes. The whole concept needs to be based on existing fireld value. Note that some characters are not allowed in Sheet names and may cause errors. Also remember that you cannot have 2 the same sheet names in Excel and the last thing to remember is that you will get as many sheets as many unique values are currently in the table you are "looping through" in <Page> node tag

For the sake of this exercise i did following:

1.  Created in Qlik Script island table with required value(s) for my sheet names
   • 
2.  Inspect result
   • 
3. Add required field as Page node in NPrinting template (this automaticaly changes sheet name!!)
   • 
4. Add a coresponding table so i can derive Year value (this is only in case you would have multiple sheets)
   • 
5. Run report
   • 

Hope this helps

regards

Lech

[Danijel]

Hi, Lech,

thank you for the good manual.

My problem at the point, I don't just have a tabsheet that has a dynamic name.

Problematic at your solution, I would have to sort the values accordingly and would also have to delimit the values within the sheet accordingly.

This means for me currently that I will use a fixed name.

Thanks anyway.

[Lech_Miszkiewicz]

Hi, no worries,

Well - if we know what is your requirement we could give you more detailed guidance as to how to make your sheets static and dynamic at the same time.

With NPrinting development you need to know the "full picture" so you can plan it ahead!

[Danijel]

Hi, Lech,

my current intention:

I have an Excel report with four tabs.

These tabs are each double, only time-limited with filters.

For example:
Sheet A - previous month
Sheet A - current year
Sheet B - Previous month
Sheet B - current year

As said in the sheets are the same elements, only with another filtering.

Greetings.