Any alternatives for empty expression in a Pivot table ?

[#1]

Hi All,

I have created a Pivot Table with 3 dimensions. However, Pivot table requires an expression which I have created an empty one in order to show the data(in text form).

The result is what I wanted with one minor issue.  There is a empty row at the end of each row for each group.  Below illustrate an example with highlighted rows:

You may ask why I don want to create an expression.  This is because I have tried to create one but the data displayed is not what I want.  Eg. If I create an expression, the "this is a comment 2" will not be shown.  They will show only one comment per qns instead which to me is loss of data displayed.

Any one has encounter similar problem before that can help on this ?

Would appreciate some help here.

thanks!

[qlikpahadi07 · Accepted solution]

Check my Solution attached :

I think i understood your problem correctly it's working with Data so must b with Blanks .