Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

okolyug16
Contributor II

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!

1 Solution

Accepted Solutions
okolyug16
Contributor II

Re: Help - Alternative to EDATE function in QlikSense

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

4 Replies

Re: Help - Alternative to EDATE function in QlikSense

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.

okolyug16
Contributor II

Re: Help - Alternative to EDATE function in QlikSense

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

okolyug16
Contributor II

Re: Help - Alternative to EDATE function in QlikSense

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

Re: Help - Alternative to EDATE function in QlikSense

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

Best,

Sunny

Community Browser