topic Re: Sum of variable in Set Analysis not working in QlikView

Sum of variable in Set Analysis not working

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

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

olivierrobin — Fri, 08 Jun 2018 13:56:54 GMT

hello

could you detail : it's not working

wrong result ? no result ?

did you try to check each part of your expression ?

amijit_hazarika — Fri, 08 Jun 2018 14:02:06 GMT

No, Individually also it is not working.

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

olivierrobin — Fri, 08 Jun 2018 14:05:59 GMT

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 — Fri, 08 Jun 2018 14:18:42 GMT

It's just giving me a - (dash)

olivierrobin — Fri, 08 Jun 2018 14:23:08 GMT

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