topic Merge multiple cells into a table header in QlikView

Merge multiple cells into a table header

harson — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Since I have not found any discussions to answer my problem, I create this new discussion in order to have your help regarding the fusion of cells in the table header as in the figure below.

Do you have any idea how to perform this action under QlikView?

Thank you in advance for your answer.

Tsiry

Re: Merge multiple cells into a table header

Anonymous — Tue, 04 Apr 2017 05:47:03 GMT

Tsiry,

Am not sure if that's possible but , a work around can be implemented using text boxes. Place the text boxes over the table headers. Make the labels of the fields in table as empty and make the text boxes transparent.

Lets see if someone provides a better solution.

Re: Merge multiple cells into a table header

Anil_Babu_Samineni — Tue, 04 Apr 2017 05:50:49 GMT

Will try out if you would provide sample data

Re: Merge multiple cells into a table header

vinieme12 — Tue, 04 Apr 2017 06:19:59 GMT

please post some sample data

Re: Merge multiple cells into a table header

harson — Tue, 04 Apr 2017 08:45:09 GMT

here

Items,car,pqt,Sct,PU

L00123,2,20,200,200.03

Re: Merge multiple cells into a table header

avinashelite — Tue, 04 Apr 2017 09:13:25 GMT

Create a inline table like below and add the dimension in the pivot

LOAD * inline

[

Dim1,Measure

car,Unit

pqt,Unit

Sct,Unit

];

rename Dim1 as per you column name which hold the car,pqt,Sct data and then add Measure to you dimension

Hope this helps you

Re: Merge multiple cells into a table header

Anil_Babu_Samineni — Tue, 04 Apr 2017 09:13:47 GMT

I got like below, And then you can take help from Custom Format Cell (Ctrl + G). Enclosed Attached

After Format Cell work around it will work like as you expected (Hope so, try from your end to remove before cell or change BG color for that)