Pivot Tables and adding in Blank Rows

[james]

All, I know you can add in "Blank Expressions" to simulate blank rows, however, I need to use Dimensions for the rows and not expressions and the Field is called "group"

Does anyone know how to add in a fake or blank segment so that e.g. revenues can have separations to make a cleaner look?

I am using a pivot table and would love the blank lines so that the pivot table would be cleaner from a end user perspective

[#2]

i am also searching for the same argument, but the only solution is (probably) to use straight table

[marcus_sommer]

The easiest way is to add a further dimension as a clone from group then you have a further total-row which you could use with if(dimensionality() = 1, ....

Further you could add a blank-value to group within your datamodel:

blank:

Load * Inline [

group

""

];

Or you could create a dynamically dimension: http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions

- Marcus