SET ANALYSIS WITH DATES NOT WORKING

[#1]

CAN SOMEONE PLEASE HELP ME.  I AM NOW AT A POINT WHERE I WANT TO BREAK MY COMPUTER LOL.

WHY DOESNT THIS WANT TO WORK CORRECTLY:

sum( {$<DATE = {'>=$(=weekstart(max(DATE)))<=$(=max(DATE))'}>} timeworked )

IT STILL PULLS ALL THE DATA AND NOT ONLY THIS WEEKS DATA...

i EVEN TRIED ADDING THE NUM() FUNCTION, DOENST WORK EITHER

[#2]

I have realised that the issue is the MAX function.  It gives an error, any ideas why?

[#3]

Carel,

please check in your expression editor if DATE is highlighted red or blue. If it's blue QV is not recognizing DATE as a field name but as a function.

[#4]

How you are saying there is a problem with max function.

can you explain briefly and if u can able to attach sample file will be useful to find the issue.

[#5]

Hi,

I attached the model,

Thanks

[#6]

try the following expression,

=sum({<DATE={">=$(=date(weekstart(max(DATE)),'YYYY/MM/DD')) <=$(=date(max(DATE),'YYYY/MM/DD'))"}>}timeworked)

there is no data for 30th sep 2013.

select the date 18th sep, or select aug month or select any month where u have the data.

[Gysbert_Wassenaar · Accepted solution]

To begin with the max Date is 30/09/2013 and there's no data for that date. If you select for example 18/09/2013 there is data. But you need to specify the date format YYYY/MM/DD. See attached qvw.

[#8]

Hey Carel,

the following formula works in your app.

=sum({<date={'>$(=(floor(num(max(DATE))))-7)'}>}timeworked)

[#9]

Thanks everyone, sorted