Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner
Partner

Extra subtotals

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

Is thsi possible with QlikView

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

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

3 Replies
alexandros17

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

jerem1234
Specialist II
Specialist II

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

Clever_Anjos
Employee
Employee

Change your expression into

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

sum(Amount)

)