topic need quick help with set analysis in QlikView

need quick help with set analysis

rohanmayekar — Tue, 07 Nov 2017 16:26:31 GMT

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

sunny_talwar — Tue, 07 Nov 2017 16:42:50 GMT

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))

rohanmayekar — Tue, 07 Nov 2017 16:46:54 GMT

Thanks For the help and explanation.