Extra subtotals

[francisvandergr]

I wanna see no extra subtotal when i have one item in a column. I have included an example.

Is thsi possible with QlikView

[alexandros17]

Go in presentation tab and click the checkbox "show partial sum" for the needed dimension

[jerem1234 · Accepted solution]

You'll have to make use of dimensionality in your formula in that case like:

if(dimensionality()=2 and count(total <Rubric> distinct Costno)=1, null(),

if(dimensionality()=1 and count(total <No> distinct Rubric)=1,null(),sum(Amount)))

This does it if there is only one Costno and also if there is only one Rubric (like Tax).

Please find attached.

Hope this helps!

[Clever_Anjos]

Change your expression into

if(Dimensionality()=0 and count(DISTINCT No) = 1, null(),

sum(Amount)

)