topic Group headings in table with one heading in QlikView

Group headings in table with one heading

Mon, 04 Nov 2013 15:36:03 GMT

I have been trying to work this out all day and I could really use some help.

I have a table in excel that looks like this:

How can I manage to get the grouping of headings in QlikView?

I found this example: http://community.qlik.com/thread/3098

Unfortunately I have not been able to replicate the solution. If anyone can explain the above link to me, I will be very greatful.

Thank you in advance.

Re: Group headings in table with one heading

Gysbert_Wassenaar — Mon, 04 Nov 2013 15:46:06 GMT

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.

Re: Group headings in table with one heading

Tue, 05 Nov 2013 06:39:24 GMT

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 JohnW

This: testPivotHeaderGroups.qvw

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.

Re: Group headings in table with one heading

sadickbasha — Tue, 05 Nov 2013 07:08:32 GMT

Hi Hoyos,

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

Re: Group headings in table with one heading

Tue, 05 Nov 2013 08:53:30 GMT

Hi,

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

requirements.

PFA the same qlikview doc, but with the dimensions aligned vertically.

Regards,

Anju

Re: Group headings in table with one heading

Tue, 05 Nov 2013 19:50:52 GMT

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:

Period, Column

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.

English:

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 [

Period,Column

Month,Actual Mth

Month,Budget Mth

YTD,Actual YTD

YTD,Budget YTD

YTD,Variance YTD

];

Can you see the similiarties ?