Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
noemibuscemi01
Partner - Contributor III
Partner - Contributor III

If statement into sum and set analysis

How can I add the if statement into the following sum?

=sum({<
[BadRate.Quarter] = {$(=$(vQuarterLLP))}
>}
[BadRate.Mature_BR3_F3])

if statement:
if [BadRate.Mature_BR3_F3] = 0, null(), [BadRate.Mature_BR3_F3]

 

Thanks!

1 Reply
Anil_Babu_Samineni

Perhaps this

=sum({<[BadRate.Quarter] = {$(=$(vQuarterLLP))}>} If([BadRate.Mature_BR3_F3] = 0, null(), [BadRate.Mature_BR3_F3]))

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