This content has been marked as final. Show 1 reply
There are 2 approaches:
- You clone the straight table in QlikView and using the Dimension Limits of the cloned object, restrict to the top 10 values. Use that object in an HTML report.
- You create the report in Excel and only bring in rows 1-10 in the properties grid for the object in NPrinting. From there, add the Excel report to your task but choose HTML as the output format. This will allow you embed the report in the email: Select Top Ranks from QlikView and Use Them With Custom Excel Formulas
No matter which approach you take, you will have to sort the object in QlikView for descending by expected percentage. NPrinting will not sort the data.