Then the content of the set modifier is what is causing the issue. Since syntax seems to be fine, the question is has field Dataven the same exact format returned by the TimeStamp() function? Are "div1" and "dfv1" fields or variables? What does the TimeStamp() function return?
Well, that's not correct. By default, TimeStamp() returns date and time, while MakeDate() returns only the date part.
A very simple check is creating a new text object and write in it
=Match(TimeStamp(40400), MakeDate(2010, 8, 10))
Both 40400 (which I assume is what the variable is storing) and 10/08/2010 (which I assume is what the field stores) refer to the same, the former in QlikView's numeric date format, the second in 'DD/MM/YYYY' string format. Obviously, the result of the expression above is "0" meaning "no match". "10/08/2010 0:00:00" is not equal to "10/08/2010".
However, representing the result of the date part from the TimeStamp() into a text will return a "1" (match)
You need to be very careful with the set analysis expressions, quoting and formats. Going one step easier, the TimeStamp() function is no longer needed, but it keeps matching:
And that should return the aggregated sum of the values in field QtaTot except those where Dataven is between the range selected. If the above still doesn't work means that formats are still different, and you will need to use the date functions in both the script for the field Dataven and the variables in the set modifier to make them alike. Starting from here, the Aggr() should work as well.
.png "Miguel_Angel_Baeyens"){kind=avatar}
