Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

Why is the output value 0?

=Aggr(if([Average] <= [Spec (Upper limit)] and [Average] >= [Spec (Lower limit)],1,0),Id)) 

and This 

=Sum(Aggr(if([Average] <= [Spec (Upper limit)] and [Average] >= [Spec (Lower limit)],1,0),Id))

Same this return is 0. 

Why is the resulting value not sum the value 1 return the loop if ?

0 Replies