Discussion Board for collaboration related to QlikView App Development.
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!
View solution in original post
Go in presentation tab and click the checkbox "show partial sum" for the needed dimension
Change your expression into
if(Dimensionality()=0 and count(DISTINCT No) = 1, null(),