topic Re: Set analysis on an equation in QlikView

Set analysis on an equation

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

Hi All

i am trying to use set analysis of an equation, let me explain i have an equation which as follows

sum ([Total fresh quantity])-(sum((([Total fresh quantity]*[Rejection %])/100)+[Weight of clay]))

and i want to apply set analysis condition

{1<Supplier={'K1'}, Month={'December'}>}

this is how i write it

(sum( {1<Supplier={'K1'}, Month={'December'}>}[Total fresh quantity])-(sum((([Total fresh quantity]*[Rejection %])/100)+[Weight of clay])))

the output isn't correct can anyone advice

sunny_talwar — Thu, 16 Feb 2017 19:34:03 GMT

May be this:

Sum({1<Supplier={'K1'}, Month={'December'}>} [Total fresh quantity]) -

Sum({1<Supplier={'K1'}, Month={'December'}>} (([Total fresh quantity]*[Rejection %])/100)+[Weight of clay])

Anonymous — Thu, 16 Feb 2017 19:39:50 GMT

perfect thank you very much