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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want the sum of the values ​​1 that enters the loop if.

Suchanan_0-1666428057808.png

 

I want the sum of the values ​​1 that enters the loop if.

 

 

5 Replies
MarcoWedel

care to elaborate?

Sxbbb
Creator III
Creator III
Author

 

2022-10-24_13-35-54.png

Requires a sum for which the output value is 1. all from the if loop
Sxbbb
Creator III
Creator III
Author

@MarcoWedel  elaborate

Sxbbb
Creator III
Creator III
Author

The total value must be the same.

 

Suchanan_0-1666603843805.png

 

Sxbbb
Creator III
Creator III
Author

In the table below, use Loops
if( [Average] <= [Spec (Upper limit)] and [Average] >= [Spec (Lower limit)],1,0) and press Sum Row. The table above uses the post image code and the value is not correct.

Suchanan_1-1666604828791.png