# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner

## need quick help with set analysis

following expression giving error,

=sum({< STDSalary-ActualSalary = {">=0"} >}STDSalary-ActualSalary)

but following works fine,

=sum({< Diffsalary = {">=0"} >}STDSalary-ActualSalary)

requirement is to get 1st expression working as Diffsalary is dummy column i am using for testing purpose

 Name STDSalary ActualSalary DiffSalary Josh 2020 3000 980 James 7000 7500 500 Ron 6500 7100 600 may 5000 5100 100 Lois 2700 2901 201 rock 990 1001 11 jaimey 990 878 -112 Lisa 900 800 -100 diana 1767 1600 -167 hamosh 2000 1800 -200 ali 1200 980 -220 daisy 2323 1200 -1123 linda 2000 200 -1800 alex 17899 15000 -2899
Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: need quick help with set analysis

The first one doesn't work because you are not allowed to use calculations/functions on the left hand side of the modifier... may be you can use this

=Sum({<Name = {"=STDSalary - ActualSalary >= 0"}>} STDSalary-ActualSalary)

or this

Sum(If(STDSalary - ActualSalary >= 0, STDSalary - ActualSalary))

or this

Sum(RangeMax(STDSalary - ActualSalary, 0))

2 Replies
MVP

## Re: need quick help with set analysis

The first one doesn't work because you are not allowed to use calculations/functions on the left hand side of the modifier... may be you can use this

=Sum({<Name = {"=STDSalary - ActualSalary >= 0"}>} STDSalary-ActualSalary)

or this

Sum(If(STDSalary - ActualSalary >= 0, STDSalary - ActualSalary))

or this

Sum(RangeMax(STDSalary - ActualSalary, 0))

Partner

## Re: need quick help with set analysis

Thanks For the help and explanation.