Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
If you want to have a different worksheet for each distinct value of PRoduct you need to insert the field Product in the Pages node. All QlikView or Qlik Sense objects you will place in the worksheets that is active at the moment you insert Products field in Pages node will be filtered by the value of the PRoduct. Read https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/Create-Excel-Repor...
If you add the Product field in the Levels node you will have a single worksheet with the list of distinct product values. All objects between the level tags are filtered. Read https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/More-Levels-Excel-...
If you need more help, please share at least your template with us so we can check your details.
Best Regards,
Ruggero