Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Partner
Partner

Formula in Excel Sheet Names?

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.

formula.png

I'am doing something wrong, bug or feature?

Thanks and greetings

Labels (1)
4 Replies

Re: Formula in Excel Sheet Names?

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
    • 1.PNG
  2.  Inspect result
    • 2.PNG
  3. Add required field as Page node in NPrinting template (this automaticaly changes sheet name!!)
    • 3.PNG
  4. Add a coresponding table so i can derive Year value (this is only in case you would have multiple sheets)
    • 4.PNG
  5. Run report
    • 5.PNG

Hope this helps

 

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Partner
Partner

Re: Formula in Excel Sheet Names?

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.

Re: Formula in Excel Sheet Names?

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!

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Partner
Partner

Re: Formula in Excel Sheet Names?

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.