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).
Where you can take vVar from an input object. Not sure if Qlik Sense has an input object, but I am sure there are extensions which might be able to help you take user input which can then be saved into a variable.