5 Replies Latest reply: Dec 27, 2017 7:28 PM by Sunny Talwar RSS

    Nested if with And issue

    Arvind Verma


      I am creating a Calculated Field when uploading data through Data Manager in Qlik Sense

      the formula for the calculated field is as follows:


      if(FlgtHour<=10,'1st Wave',

      If(FlgtHour>10 and FlgtHour<=16,'2nd Wave', 'Final Wave'))


      If I don't have the 'and' keyword in the second expression it works - as soon as I incorporate the 'and' it fails.


      Does the 'and' not work when creating a calculated filed in Data Manager?


      Its driving me ....