Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
cena_abhishek
Contributor
Contributor

How does calculation time depend on 'IF' condition

How does my calculation time of a measure depend on nested 'If' statement?

I have expressions which have atleast 4 nested 'If' statements. I want to know how does calculation time depend on nested 'If'?

1 Reply
Anil_Babu_Samineni

May be this?

If(FieldName = 'A', Sum(Sales),

     If(FieldName = 'A1', Sum(Sales1),

          If(FieldName = 'A2', Sum(Sales2),

               If(FieldName = 'A3', Sum(Sales3)

                 )

             )

        )

  )

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