Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
krissy_s
Contributor III
Contributor III

If sum of dimensions < 0 in set anslysis

Hello!
I would like count the number of records with a total amount of the following fields, which contain numeric characters, being less than 0, in a set analysis:

BUILD_MSUMINSD

PLANT_SUMINSD

i.e. if(sum(BUILD_MSUMINSD, PLANT_SUMINSD)<0). So how to write "if the sum of BUILD_MSUMINSD plus PLANT_SUMINSD < 0, using an if statement please.

Many thanks

1 Solution

Accepted Solutions
Anil_Babu_Samineni

if(Rangesum(BUILD_MSUMINSD, PLANT_SUMINSD)<0)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

if(Rangesum(BUILD_MSUMINSD, PLANT_SUMINSD)<0)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
krissy_s
Contributor III
Contributor III
Author

Thank you Anil! It works!