topic Re: Set Analysis Using Not Equal To a Date Range in QlikView

Set Analysis Using Not Equal To a Date Range

Mon, 16 May 2016 18:07:53 GMT

I am trying to count a list of claims where the assignment date is within a variable range, the creation date is before the begin date of the variable range, and the reopen date is not within the variable range. There may not be a reopen date. It appears if there is not one the field value is set to a -. I have tried both of these and get a null set:

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimReOpenDate=ClaimReopenDate-{">=$(=vBeginDate)<=$(=vEndDate)"}
>} ClaimID)

And

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimReOpenDate-={">=$(=vBeginDate)<=$(=vEndDate)"}
>} ClaimID)

Can anyone figure out what I am doing wrong?

Re: Set Analysis Using Not Equal To a Date Range

sunny_talwar — Mon, 16 May 2016 19:26:27 GMT

What about this:

Count({<
ClaimAssignmentDate = {">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate = {"<=$(=vBeginDate)"},
ClaimReOpenDate = e({<ClaimReopenDate = {">=$(=vBeginDate)<=$(=vEndDate)"}>})
>} ClaimID)

Re: Set Analysis Using Not Equal To a Date Range

swuehl — Mon, 16 May 2016 19:29:45 GMT

Or maybe

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimID = e({<ClaimReopenDate = {">=$(=vBeginDate)<=$(=vEndDate)"}>})
>} ClaimID)

Excluding values in Set Analysis

Re: Set Analysis Using Not Equal To a Date Range

sunny_talwar — Mon, 16 May 2016 19:35:19 GMT

Stefan -

I think you need to highlight what you have done differently, I spent 2 minutes figuring out what exactly was different

Re: Set Analysis Using Not Equal To a Date Range

swuehl — Mon, 16 May 2016 19:50:38 GMT

It's the italic text beginning of 4th line