topic Previous Week Sales Calculation Issue in QlikView

Previous Week Sales Calculation Issue

Thu, 17 Jun 2010 18:35:22 GMT

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,

Previous Week Sales Calculation Issue

Thu, 17 Jun 2010 18:42:58 GMT

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

Previous Week Sales Calculation Issue

Thu, 17 Jun 2010 20:40:58 GMT

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