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

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

bhupesh_gupta — Wed, 30 Oct 2013 11:31:28 GMT

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.

sujeetsingh — Wed, 30 Oct 2013 11:34:10 GMT

As till i know no such feature .

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

sushil353 — Wed, 30 Oct 2013 11:36:26 GMT

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 — Wed, 30 Oct 2013 11:38:27 GMT

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 — Wed, 30 Oct 2013 11:50:08 GMT

Hi Bhupesh,

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

HTH

Sushil

sujeetsingh — Wed, 30 Oct 2013 11:51:12 GMT

See this sample