5 Replies Latest reply: Apr 5, 2018 9:52 AM by Sasidhar Parupudi RSS

    Multiple variables in Set Analysis

    Amijit Hazarika

      Hello Qlik Experts,

       

      I am trying the below expression but it's not working.

       

      Any guidance would be very helpful.

       

      If($(variable1) = 0,0, ($(variable2) - $(variable1)) / $(variable2))

       

      Variable1 = Sum({<Field = {XYZ}>} Amount)

       

      Variable2 = Sum({<Field = {ABC}>} Amount2)

       

      Thanks in Advance

      Amijit