Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Will try out if you would provide sample data
please post some sample data
here
Items,car,pqt,Sct,PU
L00123,2,20,200,200.03
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
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)