topic Re: Date condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/Date-condition-in-set-analysis/m-p/131330#M755754 <HTML><HEAD></HEAD><BODY><P>Try this may be?</P><P></P><P>= Count(distinct {&lt; [Status]={'Active'}, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ID] = {"=IF(Date([Next Event Date])-Date(Today())&gt;=0 AND Date([Next Event Date])-date(today())&lt;=90, [ID])"}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;}[ID])</P></BODY></HTML> Wed, 03 Oct 2018 19:20:47 GMT vishsaggi 2018-10-03T19:20:47Z Date condition in set analysis https://community.qlik.com/t5/QlikView/Date-condition-in-set-analysis/m-p/131329#M755753 <HTML><HEAD></HEAD><BODY><P>I have below date condition.How can I put this in set Analysis ?</P><P></P><P>count(distinct&nbsp; if([Status]='Active', If(Date([Next Event Date])-date(today())&gt;=0 AND Date([Next Event Date])-date(today())&lt;=90, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ID])))</P><P></P><P>Thanks much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-condition-in-set-analysis/m-p/131329#M755753 apthansh 2020-11-25T16:16:04Z Re: Date condition in set analysis https://community.qlik.com/t5/QlikView/Date-condition-in-set-analysis/m-p/131330#M755754 <HTML><HEAD></HEAD><BODY><P>Try this may be?</P><P></P><P>= Count(distinct {&lt; [Status]={'Active'}, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ID] = {"=IF(Date([Next Event Date])-Date(Today())&gt;=0 AND Date([Next Event Date])-date(today())&lt;=90, [ID])"}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;}[ID])</P></BODY></HTML> Wed, 03 Oct 2018 19:20:47 GMT https://community.qlik.com/t5/QlikView/Date-condition-in-set-analysis/m-p/131330#M755754 vishsaggi 2018-10-03T19:20:47Z