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