topic Re: Grouping column headers in a straight table in QlikView

Grouping column headers in a straight table

Wed, 17 Jul 2013 16:56:19 GMT

This is about straight tables...

Is there a way to group column headers like this?

Rebounds		Points
Offensive	Defensive	3pointers	Dunks	Lay ups

Normally you'd only get this:

Offensive	Defensive	3pointers	Dunks	Lay ups

I'm assuming each column is an expression in a straight table.

Anyone done this?

Re: Grouping column headers in a straight table

CELAMBARASAN — Wed, 17 Jul 2013 17:19:47 GMT

Grouping column headers are posible with some work around. If possible can you attach sample app for that?

Edit: That to only in Pivot table.

Message was edited by: Celambarasan Adhimulam

Re: Grouping column headers in a straight table

jagan — Wed, 17 Jul 2013 17:23:10 GMT

Hi,

You can use pivot table for this, in straigt table Pivoting is not possible.

Regards,

Jagan.

Re: Grouping column headers in a straight table

Thu, 18 Jul 2013 12:51:36 GMT

No, I don't have anything I can upload.

I was thinking of pivot tables, but that doesn't seem to work too well because the columns are actual expressions. If I were to use a pivot table, I'd have to make each of those column headers part of some field.

Re: Grouping column headers in a straight table

marcus_sommer — Fri, 19 Jul 2013 14:25:56 GMT

See here: http://community.qlik.com/thread/73253 and http://community.qlik.com/message/298815#298815 and the attachment.

- Marcus

Re: Grouping column headers in a straight table

rsdhavle — Wed, 08 Jan 2014 10:11:00 GMT

In pivot table if want to pass expression 1,2,3 under header Group A and expression 4,5 under header Group B. How to achieve this? what condition needs to be used in the pivot table?

Re: Grouping column headers in a straight table

rsdhavle — Mon, 13 Jan 2014 10:32:18 GMT

I want structure like below:

Header 1 Header 2

Expression1 Expression2 Expression 3 Expression 4 Expression 5

Can this be achieved with pivot table? If yes kindly give detailed procedure with what expressions need to be used

Re: Grouping column headers in a straight table

renjithpl — Thu, 27 Jul 2017 20:10:07 GMT

I have the same requirement like this, can this be achieved.?

Re: Grouping column headers in a straight table

nicogene — Tue, 30 Jan 2018 17:32:38 GMT

Dear all,

We have the same requirement with Qlik Sense straight table.

How we can do that?

Thank you for your help.

Kindest regards,

Nicolas.