Most (if not all) of my qliks are pivot tables with the column pair "quantity" and "value" repeated many times. For example in a typical sales performance report I have:
|Stating Quantity | Starting Value | Purchased Quantity | Purchased Value | Sold Quantity | Sold Value | Closing Quantity | Closing Value |
What I want to do is to "group" each pair and have a group label and the labels Quantity, Value like this:
| Stating Values | Purchases | Sales | Closing Values |
| Quantity | Value | Quantity | Value | Quantity | Value | Quantity | Value |
A quick & dirty solution is to load inline the "groups", add the groups as a dimension in the pivot table and move it above the columns. A simple if(Group='Starting Values', sum(...), Group='Purchases', sum(...), etc) function in the expressions will do the job. The problem is the poor performance.
Is there another faster solution to achieve caption-grouping in qlikview?
