topic Re: Rolling date range in set analysis expression in QlikView

Rolling date range in set analysis expression

Fri, 15 Jun 2012 22:06:05 GMT

I am trying to create a set analysis expression that will select transactions that have date from today to three days ago. This is the expressionL

(Sum ({<nDate = {"$((>=num(today())-1))"}>}[Actual Input Qty]))-(Sum ({<nDate = {"$((>=num(today())-1))"}>}[Std Input Qty]))

This expression returns zero for all instances. I would appreciate any help you can provide.

Sat, 16 Jun 2012 04:30:20 GMT

Hi,

Try to get Day from NDate then using this expression:

sum({<Day= {">=$(=max(Day)-3)<=$(=max(Day))"} >} [Actual Input Qty]-[Std Input Qty])

Hope its can help you.

- Heri

MayilVahanan — Sat, 16 Jun 2012 05:35:23 GMT

Try this,

= sum({<nDate = {">= $( = max (nDate) - 3) <= $(= max(nDate) )"}>}[Actual Input Qty] - [Std Input Qty])

hope it helps

Thu, 21 Jun 2012 15:11:55 GMT

I ended up using the following after creating YearDay using the DayNumberOfYear expression in the load script:

= sum({<"YearDay" = {">=$(=max(YearDay)-4)<=$(=max(YearDay))"}>}[Actual Input Qty] - [Std Input Qty])

Thanks to those who responded.