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

    Nested if with And issue

    Arvind Verma

      Hi

      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 ....

       

      Thanks