Can I put same header in between records in a chart object?

[bhupesh_gupta]

Hi All

What I want to know is can we put same header after certain no. of record in Pivot/Straight table. As shown below.

And In between Each header I need to put two blank Rows.

Kindly help me in achiveing this functionality.

SR NO	EMP ID	EMPLOYEE  NAME	BUILDING	GENDER	LOCATION	ROUTE
SR NO	EMP ID	EMPLOYEE  NAME	BUILDING	GENDER	LOCATION	ROUTE

[sujeetsingh]

As till i know no such feature .

You can use two charts with fixed length and  Fit them as they are one .

[sushil353]

Hi,

You can put blanks in header: Chart property>presentation> wrap header text..

But i don't think that a header can be inserted in middle of the table.

HTH

Sushil

[bhupesh_gupta]

Sujeet

First I have to do it in Qlikview and when I pull these records in XLS it should be exported in the same way i.e with seperate header.

And the Chart will have many such group which need seperate header, so using different Charts is not an option

Regards

Bhupesh

[sushil353]

Hi Bhupesh,

You can use transformation steps to remove the header coming in between from your source table..

HTH

Sushil

[sujeetsingh]

See this sample