Selections Not Being Ignored

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

The set analysis below is not ignoring selections. Is there something I'm missing in the syntax to ignore selections?

These are the variable definitions: vGapStart =MonthStart(CurrentMonth-1)-3 and vGapEnd = MonthStart(CurrentMonth -1).

Set Analysis:

count({1<

Name = E( {1< PtStatus = {'IN','INO'} > + 1< DischargeDispositionID = {'AMA','LWBS'} >} )

,ErServiceDateTime = {"= date(ErServiceDateTime,'M/DD/YYYY') > date(vGapStart,'M/DD/YYYY') and date(ErServiceDateTime,'M/DD/YYYY') < date(vGapEnd,'M/DD/YYYY')"}

,ReadmittedWithin3Days = {'Y'}

>}Name)

Re: Selections Not Being Ignored

sunny_talwar — Fri, 22 Mar 2019 17:26:19 GMT

May be this

count({1<
Name = E( {1< PtStatus = {'IN','INO'} > + 1< DischargeDispositionID = {'AMA','LWBS'} >} )
,ErServiceDateTime = {"= date(Only({1} ErServiceDateTime), 'M/DD/YYYY') > date(Only({1} vGapStart), 'M/DD/YYYY') and date(Only({1} ErServiceDateTime), 'M/DD/YYYY') < date(Only({1} vGapEnd), 'M/DD/YYYY')"}
,ReadmittedWithin3Days = {'Y'}
>} Name)

topic Selections Not Being Ignored in QlikView

Selections Not Being Ignored

Re: Selections Not Being Ignored