Set analysis with multiple Date Variables

cbutcher — Mon, 12 May 2014 18:16:16 GMT

Help Please i'm have difficulty with Set below basically I need to select only ID's for a date range that are in the second date range.

This works with the static 2013 year selected:

=Count(Distinct {<_LK_Period={">=$(SelectDateFrom) <=$(SelectDateTo)"}, [PlayerMaster PeopleID] = {"=Count(Distinct {<[PlayerMaster Year Registered] = {2013}>}  [PlayerMaster PeopleID])>0"} >}[PlayerMaster PeopleID])

What I have been trying to do is get the second date range based on 2 other variable SelectDateFromPre and SelectDateFromToEand

These are the same SelactDateFrom and SelectDateTo but with Addmonths()-12 to give the previous years data.

=Count( {<_LK_Period={">=$(SelectDateFrom) <=$(SelectDateTo)"}, [PlayerMaster PeopleID] = {=Count({$ <_LK_Period={">=$(=SelectDateFromPre) <=$(=SelectDateToPre)"} >}[PlayerMaster PeopleID])>0 } >}Distinct [PlayerMaster PeopleID])

Any help would be appreciated.

Thanks

Chris

Re: Set analysis with multiple Date Variables

maxgro — Mon, 12 May 2014 18:25:28 GMT

maybe

=Count( {<_LK_Period={">=$(SelectDateFrom) <=$(SelectDateTo)"}, [PlayerMaster PeopleID] = {"=Count({$ <_LK_Period={'>=$(=SelectDateFromPre) <=$(=SelectDateToPre)'} >}[PlayerMaster PeopleID])>0" } >}Distinct [PlayerMaster PeopleID])

Re: Set analysis with multiple Date Variables

cbutcher — Mon, 12 May 2014 18:28:35 GMT

You sir are a star

Thanks

Chris

topic Set analysis with multiple Date Variables in QlikView

Set analysis with multiple Date Variables

Re: Set analysis with multiple Date Variables

Re: Set analysis with multiple Date Variables