Qlik Cloud Excel add-in: Create printing report, restrict number of rows
I am using Qlik Cloud Excel add-in to create standardize printing report. A transaction table need to print in the report per product, my user wanna keep each project in 1 page pdf, so wanna keep top10 transactions in the printing report only, while the visualization in dashboard have all transactions for user to scroll.
Is that possible i can do such row restriction in Excel add-in?
You absolutely can limit your Excel report to the Top 10 transactions per product! The crucial step is to enforce the restriction in Qlik Sense, not the Excel Add-in. Create a duplicate transaction table object in your Qlik Sense app specifically for reporting. In this duplicate object's properties, apply a dimension limit (e.g., "Show only top 10") to the Transaction ID, ranking it by your desired measure, and ensuring the limitation is grouped by Product. Then, in the Excel Add-in, use a Page or Level tag for the Product field to cycle through each product, and insert the tag for your restricted Qlik Sense table object within that loop. This setup ensures your final PDF output cycles through each product, showing only the Top 10 transactions on each product's page, keeping your main dashboard table unrestricted.
