topic Re: Date Subtraction in QlikView

Date Subtraction

evansabres — Thu, 31 Aug 2017 15:37:19 GMT

I have two fields 'Event Date' and a variable vOnSaleDate.

What I want to do is find the amount of time remaining (in a percentage) until an 'Event Date' relative to the vOnSaleDate and today's date. c

I have no idea how to structure this correctly, however this is how I envision the expression functioning.

=(([Event Date] - Today's Date)/([Event Date] -(vOnSaleDate))

Ultimately, if vOnSaleDate = '9/16/2017', the 'Event Date' is 10/5/17' and today's date is 09/20/2017, I want to end up with 83%, indicating that there is 83% of time remaining until the event date relative to the on-sale date.

Re: Date Subtraction

sunny_talwar — Thu, 31 Aug 2017 15:42:28 GMT

May be this

=([Event Date] - Today())/([Event Date] - $(vOnSaleDate))

Re: Date Subtraction

sunny_talwar — Thu, 31 Aug 2017 15:44:57 GMT

Or this

=([Event Date] - Today())/([Event Date] - vOnSaleDate)

Re: Date Subtraction

evansabres — Thu, 31 Aug 2017 15:45:35 GMT

This is what I have in my original question, that should work?

Re: Date Subtraction

sunny_talwar — Thu, 31 Aug 2017 15:47:25 GMT

I think so... beside you had Today's Date and I replaced it with Today()... and then there were some extra parenthesis that i got rid of ... So, in your current state your expression would probably have not worked.... but yes, in general your expression should work

Re: Date Subtraction

its_anandrjs — Thu, 31 Aug 2017 15:49:23 GMT

Try this

= ( ( ( [Event Date] - Today() ) / ( [Event Date] - (vOnSaleDate) ) ) * 100

= ( ( ( [Event Date] - Today() ) / ( [Event Date] - $(vOnSaleDate) ) ) * 100