topic SuperHeading in a Pivot Table in QlikView

SuperHeading in a Pivot Table

Tue, 11 May 2010 08:16:50 GMT

Hi,

I am configuring a Pivot Table. I have some Expression Columns.

Now, I want to display a Super Heading for all the Headings of the Expression Columns.

Something as shown below.

Super Heading
Expression Header -1	Expression Header -2	Expression Header -3	Expression Header -4	Expression Header -5
Data	Data	Data	Data	Data
Data	Data	Data	Data	Data

Please let me know if you need more information.

Thanks & Regards,

Rohit

SuperHeading in a Pivot Table

spsrk_84 — Tue, 11 May 2010 11:14:37 GMT

Hi,

I think the above format is not possible,max u can drag the dimesion horizantally or vertically..........

Regards,

Ajay

SuperHeading in a Pivot Table

Tue, 11 May 2010 11:19:47 GMT

Hi Rohita,

Cant you give the super heading as the chart name. So that it is displayed on top of the chart. I dont know if this is what you are looking for. hope this helps you.

Thanks Joseph......

SuperHeading in a Pivot Table

Tue, 11 May 2010 11:30:47 GMT

Hi all,
I find this post very usefull
http://community.qlik.com/forums/p/27850/106611.aspx

Alex

SuperHeading in a Pivot Table

Tue, 11 May 2010 12:16:52 GMT

Thanks all for your replies 🙂

SuperHeading in a Pivot Table

Tue, 11 May 2010 13:01:35 GMT

Take a look at the attached, see if this is what you're after.

SuperHeading in a Pivot Table

Tue, 11 May 2010 13:15:30 GMT

Hello Nigel,

This is exactly what I want. Can you please explain that how did you achieve this.

Thanks & Regards

Rohit

SuperHeading in a Pivot Table

Tue, 11 May 2010 13:59:07 GMT

Sorry, been in a meeting for a while, so just seen this.

All I did was to add another dimension to the pivot chart, the dimension is a calculated dimension which simply contains the heading that you want to see. The label for the dimension is blank (it's important that you actually put a space into the label otherwise it will use the expression itself as a label).

Final thing is to simply drag the dimension to the vertical as you would normally do with any dimension you want across the top.

This doesn't change any granularity of the pivot, because the dimension value is the same for every row you show, but a word of warning is that I put this together in 5 minutes before my meeting, so I really haven't fully tested it against a dataset (although I see no reason why it shouldn't work).

Glad it helps,

SuperHeading in a Pivot Table

Tue, 11 May 2010 14:27:42 GMT

Thanks a lott!!!

It's great 🙂