topic Re: Greater Than Today in QlikView

Greater Than Today

Anonymous — Tue, 10 Jan 2017 13:24:40 GMT

I am trying to only sum subscription amounts where the subscription end date is greater than today to get a true view of our customer subscription amount day by day.

I referenced this post: Greater than today date

to create the set analysis below, but it is not working.

Any ideas?

=sum({$< [Subscription End Date] = {">= $(=Date(Today(),'MM/DD/YYYY'))"}>}[Amount])

- dave

Re: Greater Than Today

sunny_talwar — Tue, 10 Jan 2017 13:30:41 GMT

Is Subscription End Date a date or timestamp field? Its format is MM/DD/YYYY?

Re: Greater Than Today

Anonymous — Tue, 10 Jan 2017 13:33:36 GMT

This is how I formatted Subscription End Date in the load script

Date("Subscription End Date",'MM/DD/YYYY') as [Subscription End Date],

Re: Greater Than Today

sunny_talwar — Tue, 10 Jan 2017 13:35:01 GMT

Try this:

Date(Floor("Subscription End Date"),'MM/DD/YYYY') as [Subscription End Date],

Re: Greater Than Today

Anonymous — Tue, 10 Jan 2017 13:35:05 GMT

Solved it. I had to delete the spaces in the set analysis between all of the different characters. Seems like the syntax is very sensitive.

Re: Greater Than Today

Anonymous — Tue, 10 Jan 2017 13:35:34 GMT

I had spaces in set analysis that were preventing it from working. Thank you for your feedback.