Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis on an equation

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Not applicable
Author

perfect thank you very much