Solved: Extra subtotals - Qlik Community

francisvandergr · ‎2014-02-26

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

Is thsi possible with QlikView

jerem1234 · ‎2014-02-26

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!

alexandros17 · ‎2014-02-26

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

jerem1234 · ‎2014-02-26

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 · ‎2014-02-26

Change your expression into

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

sum(Amount)

)