QlikView Developer — Question 5

A customer needs to produce formatted output as a PDF to distribute it to non-QlikView users. Each page should show sales trending for a different sales team.
The number of sales teams will change frequently. What should a developer create to efficiently enable users to create the required output?

Answer options

• A. a report with banding on SalesTeam
• B. a report with GROUP BY on SalesTeam
• C. separate reports with where clauses for each SalesTeam
• D. separate reports referencing bookmarks for each SalesTeam
• E. a report that uses current selections where the user selects each SalesTeam in turn

Correct answer: A

Explanation

The correct answer, A, suggests using a report with banding on SalesTeam, which allows for dynamic and efficient formatting based on the varying number of sales teams. Options B, C, and D are less efficient because they either require static grouping, multiple reports, or manual adjustments for each sales team, which does not accommodate frequent changes efficiently. Option E involves user interaction for each selection, which could be cumbersome for regular reporting.