Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wanna see no extra subtotal when i have one item in a column. I have included an example.
Is thsi possible with QlikView
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!
Go in presentation tab and click the checkbox "show partial sum" for the needed dimension
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!
Change your expression into
if(Dimensionality()=0 and count(DISTINCT No) = 1, null(),
sum(Amount)
)