topic Re: Set Analysis between two dates in QlikView

Set Analysis between two dates

billuran — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I want to do set analysis with dates. Here is my basic function:

sum(Hours)

My date Field is PP

I want sum hours that are equal to or between the max available date and 42 days before this.

Here is my first attempt.

sum({<[Exclude Hours]={'NO'},PP={'>=$(=Date(max({1}PP)))<=$(=Date(max({1}PP)-42))'},Overtime={'OT'}>} Hours)

It however is not working for the specified date range

swuehl — Thu, 16 Mar 2017 21:20:35 GMT

shouldn't it be like

PP={'>=$(=Date(max({1}PP)-42))<=$(=Date(max({1}PP)))'}

billuran — Thu, 16 Mar 2017 21:24:27 GMT

Stefan, As always thank you. Silly by me...