merge cells in a table diagram

[#1]

Hello QV community,

is it possible to merge in a table diagram cells like in Excel?
I have e.g. in one row a monthly split but in the next row it should merge all months as a yearly value.

Thanks for your tips

Regards

Martin

[tresesco]

There is no direct way, have a look at  this discussion: Merge headers in pivot table

[#3]

Hi Martin,

You can merge cells in Pivote table by maintaining hierarchy in the Dimension. But ofcourse it will not be exactly like Excell, you can not manualy merge cells!!

- Yojas

[#4]

Hi

it should be like that

is this possible to show in Qlikview in one table?

[#5]

Hi Martin,

  You can not merge the two cells like excel in Qlikview. but you can increase the width of the cell through the presentation tab of the tble properties "Multiline Setting---> Wrap Cell text Height"

[#6]

Hi Martin,

Then you should need to have a one more dimension as quarter and then enable the partial sums of that.