Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mpressey
Creator
Creator

Selections Not Being Ignored

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)

 

 

1 Reply
sunny_talwar

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)