topic analysis for periods in QlikView https://community.qlik.com/t5/QlikView/analysis-for-periods/m-p/445800#M166307 <HTML><HEAD></HEAD><BODY><P>Hello everyone, </P><P></P><P></P><P>i have tried&nbsp; work in a indicator of a health industry, in one of this indicator i need a filter that count every patients that have a new episode in the database, and also is active in a other database, something like this:</P><P></P><P></P><P>Patient: Pepita Perez</P><P>episode date: 20120302</P><P>period of activation: 20120203&nbsp; to 20120301 </P><P></P><P></P><P>this person isn't count in my indicator, because she doesn't active.</P><P></P><P></P><P>i tried to do this: </P><P>count({&lt;&nbsp; episodeDate = {$(='&gt;='&amp; DateBegin)}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,episodeDate&nbsp; = {$(='&lt;='&amp; DateEnd)}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;} patient)</P><P></P><P></P><P>but, didn't work&nbsp;&nbsp; </P><P></P><P></P><P>i'm new of this kind of proyect, please help me&nbsp;&nbsp; </P></BODY></HTML> Tue, 23 Oct 2012 20:16:22 GMT 2012-10-23T20:16:22Z analysis for periods https://community.qlik.com/t5/QlikView/analysis-for-periods/m-p/445800#M166307 <HTML><HEAD></HEAD><BODY><P>Hello everyone, </P><P></P><P></P><P>i have tried&nbsp; work in a indicator of a health industry, in one of this indicator i need a filter that count every patients that have a new episode in the database, and also is active in a other database, something like this:</P><P></P><P></P><P>Patient: Pepita Perez</P><P>episode date: 20120302</P><P>period of activation: 20120203&nbsp; to 20120301 </P><P></P><P></P><P>this person isn't count in my indicator, because she doesn't active.</P><P></P><P></P><P>i tried to do this: </P><P>count({&lt;&nbsp; episodeDate = {$(='&gt;='&amp; DateBegin)}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,episodeDate&nbsp; = {$(='&lt;='&amp; DateEnd)}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;} patient)</P><P></P><P></P><P>but, didn't work&nbsp;&nbsp; </P><P></P><P></P><P>i'm new of this kind of proyect, please help me&nbsp;&nbsp; </P></BODY></HTML> Tue, 23 Oct 2012 20:16:22 GMT https://community.qlik.com/t5/QlikView/analysis-for-periods/m-p/445800#M166307 2012-10-23T20:16:22Z