Partitial sum of 1 expression (more in pivot)

[francisvandergr]

I like to see partitial sum of 1 expression. . Is this possible? .

I have more dimensions in my pivot. I included an example.

[Saravanan_Desingh]

Please try this..

If(Dimensionality()=2,sum(Quantity))

[sunny_talwar]

Inbuilt QlikView's functionality doesn't allow for only one subtotal. A dirty work around I have used in the past it to put a straight table next to it and give it a feel of total column.

[sunny_talwar]

I think you mean this:

If(SecondaryDimensionality()<>0, Sum(Quantity))

But this would only make the Total to show nulls, the column itself won't go away.

[Saravanan_Desingh]

Sunny is correct. You have transposed the Row to Column.

In that case Dimensionality has to be changed to SecondaryDimensionality

[sunny_talwar · Accepted solution]

Closest you can get is this:

Let me know if you need help with understanding what I did. Added couple of Inline Tables in the script.