topic Re: Multiple header rows in latest version in QlikView

Multiple header rows in latest version

Thu, 21 Feb 2013 23:55:29 GMT

Hi everyone,

Is it still not possible to add a stright row to a table header in the latest version of QlkView? I want to have 2 rows in the table header.

I know there are some work-arounds using Pivot table, but I am using a sright table with more than 25 columns. Please advise , thanks in advance!!

Re: Multiple header rows in latest version

Fri, 22 Feb 2013 00:15:10 GMT

Do you mean you have an extra header row in a table file that you are loading via script? Or that you have a table in your data model, presenting it with a Straight Table chart, and want multiple header rows? If you will clarify a bit, I will try to help.

Re: Multiple header rows in latest version

Fri, 22 Feb 2013 00:52:20 GMT

Am talking about adding an extra "header row" to a straight table chart object in QlikView.

Re: Multiple header rows in latest version

Fri, 22 Feb 2013 01:16:08 GMT

Well, of couse you can choose to wrap the Header row text as much as needed on the Presentation tab in the Multiline Settings. Will that not work for your application?

Re: Multiple header rows in latest version

Fri, 22 Feb 2013 01:30:13 GMT

No it won't. I need to have a header with the foillowing format.

Test Header1		Test Header2
Column1	Column2	Column3	Column4	Column5

So therecis no way to do this in QlikView? This is a pretty common requirement.

Re: Multiple header rows in latest version

Fri, 22 Feb 2013 01:54:46 GMT

I see what you mean. Indeed I think a Pivot table is the only solution there. Given you have 25 columns, no doubt the table scrolls horizontally so faking it with text boxes above is not an option.

Re: Multiple header rows in latest version

marcus_sommer — Fri, 22 Feb 2013 19:10:47 GMT

perhaps this will be helpful - is in german, but see the qvw

http://community.qlik.com/message/298815#298815

- Marcus

Re: Multiple header rows in latest version

Mon, 30 Mar 2015 18:04:25 GMT

Anybody has a solution now days for this? I need to do the same.

Re: Multiple header rows in latest version

marcus_sommer — Tue, 31 Mar 2015 06:27:11 GMT

There aren't real solutions only workarounds like within the attachment with pseudo-dimensions and/or as alternatively with several overlapping objects - then an object in qlikview is always linked to the datamodel and you need to extend these datamodel (needs complex dimensions/expressions) or you need to embed the object in a "painted" environment.

- Marcus

Re: Multiple header rows in latest version

Anonymous — Thu, 03 Mar 2016 21:34:31 GMT

In a PivotTable upload your data.

Click Category, and then drag until the blue arrow on the column expression

will look like

Click on item and drag down Category until the blue arrow as shown below

will look like