Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Janaszek
Contributor II
Contributor II

The column is missing totals

HI, i have problem. i use : if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ]))
The column is missing totals. What can I do?

Sum(if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ])) <---NOT WORK

7195139124254871aa2fb69f075122bd (1).png

8 Replies
Vegar
Partner
Partner

Your if statement is probably false for the total row.

SUM(Document_PZ),Document_ZZ)<>0 

and therfore you gett null().

Try: sum(aggr( if(  SUM(Document_PZ)=0, Sum([Document_ZZ])),Document_ZZ))

 

I short, you need to create an expression that is valid for the expression without any dimension restrictions

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
sunsun566
Contributor III
Contributor III

Hi 

Or the other two methods for your reference. Hope it will help you:)

1. Edit Total by yourself.  Generally Total is placed in RowNo() = 0 or null. 

If it is a Pivot Table, it is ColumnNo() = 0 or null

  ex>  IF( RowNo() = 0 or Isnull(RowNo()), .....)

2. Use between two conditions "+"

 ex> 

if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ]))  + if(Aggr(SUM(Document_PZ),Document_ZZ) <> 0, 0)



Janaszek
Contributor II
Contributor II
Author

I gave the wrong data, they are correct:

if(Aggr(SUM(Quantity_Document_PZ),Document_ZZ)=0,Sum([Quantity_Document_ZZ]))

Janaszek
Contributor II
Contributor II
Author

the ideas given above don't work.
maybe it's a quantity syntax problem?

Janaszek
Contributor II
Contributor II
Author

have any ideas?

Anil_Babu_Samineni

You should include all dimensions which plot like

Sum(Aggr(if(Aggr(SUM(Document_PZ),Document_ZZ)=0,Sum([Document_ZZ])), Dimension1, Dimension2, etc.))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Lech_Miszkiewicz

If you wish to stick to If & Aggr I suggest following:

Sum( if(Aggr(nodistinct SUM(Quantity_Document_PZ),Document_ZZ)=0,[Quantity_Document_ZZ]))

 

or much better option which will be a lot better performing and not using Sum(If(Aggr: which gives me a satisfaction...

Sum({<Document_PZ={"=Sum(Quantity_Document_PZ)=0"}>}[Quantity_Document_ZZ]) 

hope this helps!

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Janaszek
Contributor II
Contributor II
Author

Thanks Lech

Sum({<Document_PZ={"=Sum(Quantity_Document_PZ)=0"}>}[Quantity_Document_ZZ]) 

this works!!!