I have to create a report that has a chart and a text box. Both the chart and the text box contain a field that needs to change page by page. The chart is pivoted by "department". The text object has the "department" field in it also. It is sort of like a sign off sheet. The top shows what the department has/does. The text object is a signoff box. There are over 100 departments. How can I use banding in the "department" field to create mutliple sheets for multiple Departments. Please take a look at the attached.
I'm sure you'll have resolved this by now, but given that I've just come across it and that there's no answer currently offered, I thought I'd give one for anyone else who comes across the same issue.
As you've selected 'Multiple Page (for long tables)' in the Page Settings section QlikView limits the number of objects that can be placed in the main section of the report i.e. it reserves that central section for what you've told it will be a large table which will likely span multiple pages. The only way that I've found to be able to place multiple objects in the central pain is to select the 'Single Page' option.