Probably easiest to use text boxes as labels. See attached example.
The alternative is to create extra dimensions like in the example from the discussion you linked to.
SalesToDate6.qvw 159.5 K
Thank you for your answer but it was not quite what I was looking for. I agree it would be easier but I wanted to replicate the linked-solution by John Witherspoon
As they discuss it enables dynamic tables, and also the possibilty of sending it to excel. Im not sure I understand the extra dimension. Is that the "Column" that you refer to. Can you explain it to me?
Thank you for your time.
The solution provided in the http://community.qlik.com/thread/3098 is simple.
* You have to create a dimension to create the group heading based on your need
* In the pivot table, you can include the dimensions whatevers is required
* all the dimensions will be displayed in left side as separate columns
* then simply drag the dimension to the top just above the expression data
* the group heading will appear as expected at the top
Du skal lave en dimension hvor du giver dine "IDer" en reference til den heading du vil have.
Så din dimension vil ligne noget ala:
Month, LY Month
Month, Act Month
QTD, LY QTD
QTD , Act QTD
osv osv. Hvis du i dine undergroups ikke vil skrive det hele fx LY QTD - Så substring det sidste afsætningen væk.
You should make a dimension where you give your "IDs" a reference to your group heading
Example from John:
So a dimension would look like this.
LOAD * INLINE [
Can you see the similiarties ?
Basically, in the example,
they have created their own dimensions, (load * inline)
, then dragged some of the dimensions horizontally to get
the required table structure.
Additionally, you could also write if statements in the expression tab to suit your
PFA the same qlikview doc, but with the dimensions aligned vertically.
Pivot Column Merge.qvw 147.8 K