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

Tags (3)
1 Solution

Accepted Solutions MVP

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 MVP

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

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

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. MVP

Re: Offset dates in set analysis

Awesome, we are glad to help 