Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @Manni_SM
If you are referring to built-in excel headers/footers then those are not accepting any NPrinting tags and you will not be able to pass anything inside of them.
My usual workaround is to put data in actual cells at the bottom or the top of the excel page (instead of utilizing built-in functionalities) and manage header and footer size to compensate for that.
Regarding variables: You need to make sure your variables are expanded already in Qlik as documented here: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/Troubleshooting/Variables-dont-...
cheers
Hi @Manni_SM
It really depends on the data and whether data in your report fits within single page or crosses over and creates multiple pages.
If it fits on single page then I tend to disable "Expand range" https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Designer-pro... and just plan the single page layout and print area
If it is multi-page then having dynamic information in a footer (information like last reload date) is not really easy to be put in as you cannot just leave variable tags at the bottom of the page as data will move it to next page. In such case we dont have much options. One thing I try to do is to convince that we could put this information on top of the page and then instead of actual header use this setting to repeat x rows of cells from the top on each page.
Other considerations. You also need to take into account what information you want to put in your footer. As an example you posted that one of the information would be page number which obviously will not come from NPrinting but it will have to be coming from native excel footer properties.
Lastly if you really need all information in footer and your report has multiple pages then it really becomes complex exercise as you need to calculate how many cells you will need to consume for header, data and footer on each page and then come up with the dynamic idea inside your Qlik app to create a dummy table which will be used to group rows into chunks which then can be placed as a level (so single value from the level produces single page output in NPrinting).
I haver done this before, but I dont think it was worth the time and effort for the result.
The approach is always individual to data model and requirements for the output so I have no example because i dont know exactly what you need. If we have clear instructions, some idea how things are in your data model (whether dimensions used are all in single table or multiple tables, what is the uniqueness of the data, whether from your example: (customer, product and order are unique keys or whether order is actualy a measure like quantity ordered?). Long story short for this complex solution you need to be able to have a single field which you can use as a "ID" to apply selection to produce single row of data. From that point it becomes mathematical exercise and Qlik challenge typically involving Rank function / dummy island tables and smart&tricky Qlik development)
Once I have very detailed instructions what the outcome needs to look like I may spend time building something dummy I could share. I just dont want to built this withouth having all the details I need.
cheers
