Help - Alternative to EDATE function in QlikSense

[Anonymous]

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!

[sunny_talwar]

May be like an expression like this:

If(AddMonths([(invoice date], vVar) > [Payment Date], 'Late', 'On-Time')

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.

[Anonymous]

Thanks for the direction Sunny!

Seems the qsVariable extension might do the trick, I'll try it out and update the post.

"What if" Analysis in Qlik Sense

[Anonymous · Accepted solution]

Update: The qsVariable works great! Attaching a sample qvf of the solution.

[sunny_talwar]

Awesome, I am glad you were able to make it work and thanks for sharing your solution with all of us.

Best,

Sunny