How to group column titles

Wed, 09 Jun 2010 10:47:04 GMT

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?

topic How to group column titles in QlikView

How to group column titles