Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmelillo
Contributor II

Greater Than Today

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

1 Solution

Accepted Solutions
dmelillo
Contributor II

Re: Greater Than Today

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.

5 Replies

Re: Greater Than Today

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

dmelillo
Contributor II

Re: Greater Than Today

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

Try this:

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

dmelillo
Contributor II

Re: Greater Than Today

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.

dmelillo
Contributor II

Re: Greater Than Today

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

Community Browser