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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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