
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help - Alternative to EDATE function in QlikSense
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!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update: The qsVariable works great! Attaching a sample qvf of the solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the direction Sunny!
Seems the qsVariable extension might do the trick, I'll try it out and update the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update: The qsVariable works great! Attaching a sample qvf of the solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome, I am glad you were able to make it work and thanks for sharing your solution with all of us.
Best,
Sunny
