Two of the tables in the QlikView data model are InvoiceHeader (one million rows) and InvoiceDetail (nine million rows) InvoicelD links the two Invoice tables.
This expression is used several times in the QlikView application, count (distinct invoiceiT)
How can a business analyst optimize this expression for use in the application?
A business analyst wants to display several dimensions and key performance indicators (KPI) in one object Aggregations must be done in this object. The user must be able to change the sorting of the dimensions and KPIs quickly and easily.
Which object meets these requirements?