Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

sum between dates

hi all,

could someone assist with syntax here. I'm trying to sum between the beginning of year to the current date.

Sum({<Date = {">=$(vYearStart) <=$(vToday)"} >} Field)  

vYearStart= YearStart(Today()) 

vToday =Date(Today())

5 Replies
MVP
MVP

Re: sum between dates

May be try like this

Sum({<Date = {">=$(=vYearStart) <=$(=vToday)"}>} Field)

Also, look here:

Dates in Set Analysis

Not applicable

Re: sum between dates

Ah I figured out syntax wasn't the issue. The field I am summing does not have a date link. Only a month. Is there a way to do a sum between first month of the year and the current month?

MVP
MVP

Re: sum between dates

How does your Month field look like?

Not applicable

Re: sum between dates

Its written out fully

January

February

March

etc

MVP
MVP

Re: sum between dates

And can you share how is this field created in the script? Essentially, is this a date field or not?