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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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