Yes - you should be able to keep slices. I find this feature very good and it helps to elevate excel reports to next level! In your case there must be something wrong with template or nodes. I am sure you can use slicers and there should not be any limitation in this area
Steps i have done to embed slicer in NPrinitng generated report
import table from Qlik to left nav nodes
drag and drop nodes to spreadsheet
convert range where my nodes are to Excel table (Insert--> Table)
create next Sheet, go to next sheet , go to some cell (say in cell 13B0 i go Insert --> PivotTable and when creating Pivot Table i point to my table name from point 3
Insert slicer above
generate report and observe results
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.
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.
Thanks for the guide, I have manged to get the pivot working and found the reason why it failed.
Below your table you have a blank row, so when Nprinting run the report there is a blank row at the end of the full populated table. this causes my slicer to fail as there is no data. If i populated the blank row with spaces it works. How did you get it to work with a blank row at the end? or is there another way to suppress the blank row.