3 Replies Latest reply: Jul 28, 2016 11:46 PM by ROSANNA LUO RSS

    if(and statement

    ROSANNA LUO

      Hello,

       

      I really need help with converting if statement on excel to Qlikview! The formula depicts the logic that if the date falls within 1st to 19th then it should be counted as of the same month, and if the date starts after the 20th then it should be counted as of the next month. Can someone give me pointers on how to achieve this on Qlikview?

       

      formula on excel:

      =IF(AND(DAY(C11)>=1,DAY(C11)<20),DATE(YEAR(C11),MONTH(C11),1),DATE(YEAR(C11),MONTH(C11)+1,1))

       

      formula on qlikeview, not working.

      =IF(AND(DAY([Opp Est Eng Start Date])>=1,DAY([Opp Est Eng Start Date])<20),DATE(YEAR([Opp Est Eng Start Date]),MONTH([Opp Est Eng Start Date]),1),DATE(YEAR([Opp Est Eng Start Date]),MONTH([Opp Est Eng Start Date])+1,1))

       

       

      Many thanks!