Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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

Perhaps this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)