topic Re: Extra subtotals in QlikView

Extra subtotals

francisvandergr — Wed, 26 Feb 2014 12:54:43 GMT

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 — Wed, 26 Feb 2014 12:57:52 GMT

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

jerem1234 — Wed, 26 Feb 2014 13:22:33 GMT

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 — Wed, 26 Feb 2014 13:27:02 GMT

Change your expression into

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

sum(Amount)

)