topic Re: Offset dates in set analysis in QlikView

Offset dates in set analysis

Fri, 18 Dec 2015 10:00:16 GMT

Hi all,

I want to get the standard deviation of a set of values. There is more than year's data in the file, but I only want to consider the values of the last 150 days in the expression. I currently have:

=Stdev({$<[process date]={">=$(Date(today()-150),'DD-MM-YYYY')"}>} [Quantity produced] )

(The format of process date is 'DD-MM-YYYY')

Can someone please point me in the right direction?

Kind regards,

Florian

Re: Offset dates in set analysis

sunny_talwar — Fri, 18 Dec 2015 11:37:57 GMT

May be try this (Edits in Red)

=Stdev({$<[process date]={">=$(=Date(Today()-150, 'DD-MM-YYYY'))"}>} [Quantity produced])

Re: Offset dates in set analysis

Gabriel — Fri, 18 Dec 2015 11:40:48 GMT

Hi,

As stated by sunindia above you need the equal (=) sign before the Date. You are using a function there is it has to evaluate and to achieve that equal sign is needed.

=Stdev({$<[process date]={">=$(=Date(today()-150),'DD-MM-YYYY')"}>} [Quantity produced] )

Re: Offset dates in set analysis

sunny_talwar — Fri, 18 Dec 2015 11:42:52 GMT

I think there is a misplaced parentheses in there too...

=Stdev({$<[process date]={">=$(=Date(today()-150),'DD-MM-YYYY')"}>} [Quantity produced])

vs.

=Stdev({$<[process date]={">=$(=Date(today()-150,'DD-MM-YYYY'))"}>} [Quantity produced] )

Re: Offset dates in set analysis

Fri, 18 Dec 2015 11:59:58 GMT

Thanks a lot, this works perfectly. Gabriel thanks for the explanation about the equals sign, I was unaware of this.

Re: Offset dates in set analysis

sunny_talwar — Fri, 18 Dec 2015 13:28:44 GMT

Awesome, we are glad to help