Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Total in Pivot not matching with EXCEL Extracted

Hi All ,

I have the Below Pivot Table created .

CTscannerPremium and CTscanner_ISP is created by expression sum(CTscanner_Premium) and sum(CTscanner_ISP) respectively . 

What i need from 3rd expression is sum of CTscanner_ISP where CTscannerPremium >0 and CTscanner_ISP >0 ( Filtering out zero's ) .

I tried with below expression 

if( sum(CTscanner_Premium) >0 and sum(CTscanner_ISP)>0 ,
sum(aggr(sum(CTscanner_ISP),[Sales Doc. #],Quarter)))

It is working fine but the total is showing wrong (4234762.98 - this is wrong) , not sure what I'm missing  - OR DO LET ME KNOW IF ANY OTHER EXPRESSION ALSO CAN BE DONE TO GET THE OUTPUT

When i extract pivot to Excel and see the total for expression 3 , its correct but not the total in pivot table . I need the sum what is shown in excel ( sum i need to get is 2764339 , I have attached the extract excel from Pivot Table - can see it for reference ) 

Do help

 

Pivot TablePivot Table

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(Aggr(
  If(Sum(CTscanner_Premium) > 0 and Sum(CTscanner_ISP) > 0, Sum(CTscanner_ISP)
, [Sales Doc. #], Quarter)))

View solution in original post

1 Reply
sunny_talwar

Try this

Sum(Aggr(
  If(Sum(CTscanner_Premium) > 0 and Sum(CTscanner_ISP) > 0, Sum(CTscanner_ISP)
, [Sales Doc. #], Quarter)))

View solution in original post