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.

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

If statement into sum and set analysis

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

[BadRate.Quarter] = {$(=$(vQuarterLLP))}

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



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)