Qlik Community

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 
Search instead for 
Did you mean: 
amijit_hazarika
Contributor III
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
olivierrobin
Specialist III
Specialist III

hello

could you detail : it's not working

wrong result ? no result ?

did you try to check each part of your expression ?

amijit_hazarika
Contributor III
Contributor III
Author

No, Individually also it is not working.

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

olivierrobin
Specialist III
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

amijit_hazarika
Contributor III
Contributor III
Author

It's just giving me a - (dash)

olivierrobin
Specialist III
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