2 Replies Latest reply: Oct 14, 2018 12:07 PM by Michael Callirgos RSS

    Expression Editor

    Michael Callirgos

       

      Hello all,
      New to Qlik Sense.  I love it! 
      In expression editor I need below.  I've tried multiple variations with no luck.  I have been successful in using this before but NOT with the (a)+(b) portion.  I've tried set analysis and did not work.  

      I don't have access to create a new field or data load unfortunately the express editor is all I have to create what I need. 

      Any suggestions?

       

        =If(home=’c’ and (a)+(b)<100,dual(‘100’,1)

       

      ,If(home=’c’ and (a)+(b)>=100 and (a)+(b)<200,dual(‘200’,1)