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

    Help - Alternative to EDATE function in QlikSense

    Ugonna Okoli

      Hi,

       

      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!