Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Offset dates in set analysis

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

1 Solution

Accepted Solutions

Re: Offset dates in set analysis

May be try this (Edits in Red)

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

5 Replies

Re: Offset dates in set analysis

May be try this (Edits in Red)

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

Partner
Partner

Re: Offset dates in set analysis

Hi,

As stated by 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

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] )

Not applicable

Re: Offset dates in set analysis

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

Awesome, we are glad to help