Previous Week Sales Calculation Issue

[#1]

I've got a really strange issue calculating previous week sales. I've gone through these here forums, tried all relate examples, and nothing. Oddly enough, i can calculate previous year sales no problem. I'm remembering to exclude the year and such in my set analysis. Below is my code, and i'm wondering if anyone sees anything glaringly wrong that i may have missed...

SUM(
{$<
 [Week Date] = {$( =DATE(ONLY([Week Date])-7) )},
 Year =,
 Month =,
 Quarter =
>}
 [Qty Sold])

Thanks for any advice/help,

[#2]

If you have many [Week Date] for current selection, the only() function will return NULL.

[#3 · Accepted solution]

I solved this one.... forgot that Qlikview in SR3 and 4 interprets a date as a number in set analysis... so my solution was to convert the date to a number in the script, then use the new field in the set analysis.

Thanks for the info on the nulls though!

-Scott