Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Take a look at the attached, see if this is what you're after.
Hi,
I think the above format is not possible,max u can drag the dimesion horizantally or vertically..........
Regards,
Ajay
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......
Hi all,
I find this post very usefull
http://community.qlik.com/forums/p/27850/106611.aspx
Alex
Thanks all for your replies 🙂
Take a look at the attached, see if this is what you're after.
Hello Nigel,
This is exactly what I want. Can you please explain that how did you achieve this.
Thanks & Regards
Rohit
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,
Thanks a lott!!!
It's great 🙂