topic Totals mistmatch in QlikView

Totals mistmatch

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

In my expression am using if condition as below

(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or WildMatch([Code], 'NP*')

([Sales Amount])

(SUM([Sales Return])

))

using this expression am getting correct values in row wise but when we check the total then we found that total is showing wrong

PFA .....

Thanks

Re: Totals mistmatch

ecolomer — Thu, 05 May 2016 04:06:04 GMT

Try with:

Sum(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or WildMatch([Code], 'NP*')

([Sales Amount])

([Sales Return])

)

(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or WildMatch([Code], 'NP*')

sum([Sales Amount])

(SUM([Sales Return])

))

Re: Totals mistmatch

PrashantSangle — Thu, 05 May 2016 05:11:23 GMT

Hi,

Is this error in pivot table?

If yes then

Not sure but try with Aggr()

try like

sum(Aggr(YourEntireExpression,Dim1,Dim2))

If in Straight table then use sum of rows in Expression tab.

Kind Regards

Re: Totals mistmatch

prma7799 — Thu, 05 May 2016 05:34:16 GMT

Thanks Max....

Can you tell me How to write this is in straight table...

Thanks