# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## Sum of variable in Set Analysis not working

Hi All,

I am stuck in a situation where I am calculating sum of a variable and it's not working.

((sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Partner Function] = {'Audit'}>}\$(vFY18TotalBURevenue))

+

Sum({<[Partner AuditSubGeo] -= {'Coastal'} , [Engagement SubGeo] = {'Coastal'}>

+ <[Partner AuditSubGeo] = {'Coastal'} , [Partner Function] -= {'Audit'}>}\$(vFY18TotalBURevenue)))

-

(sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Engagement SubGeo] -= {'Coastal'}>}\$(vFY18TotalBURevenue))))

Addition of 1st two set analysis and  then subtract the third with the resultant.

Below are the details;

vFY18TotalBURevenue  =  \$(vManagedRevenue) - \$(vOuttootherBURevenue)

vManagedRevenue = CYRevenue + PYRevenue

vOuttootherBURevenue  = OutRevenue

5 Replies
Specialist III

hello

could you detail : it's not working

wrong result ? no result ?

did you try to check each part of your expression ?

Contributor III
Author

No, Individually also it is not working.

sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Partner Function] = {'Audit'}>}\$(vFY18TotalBURevenue

Specialist III

and so what does 'not working' mean  ? no result ? wrong result ?

create a simple graph with your dimension and expressions

listboxes with the dimensions

select manually the combinations of values you use and see the result

Contributor III
Author

It's just giving me a - (dash)

Specialist III

that means null

did you see null values in one of the columns of the sum ?

ig yes, replace + with rangesum() which treats nulls as 0

Community Browser