4 Replies Latest reply: Jun 30, 2016 5:49 PM by Sunny Talwar RSS

    Help - Alternative to EDATE function in QlikSense

    Ugonna Okoli



      I need some help replicating the 'EDATE' excel function in QlikSense, I need the values of a dimension to be derived based on user entry or selection. Is this possible?


      Here's a scenario using sample data;

      Depending on the question the user needs answered, they enter a number in cell B1 and the EDATE function spits out the results in col D. In the image above if (invoice date + 2 months) > Payment Date then payment is flagged as late(TRUE).



      Any suggestions?

      Thanks in advance!