topic Re: Conditional question in QlikView https://community.qlik.com/t5/QlikView/Conditional-question/m-p/470289#M175629 <HTML><HEAD></HEAD><BODY><P>Bogd ,</P><P>Try using just interval function in script</P><P></P><P><STRONG>interval(date1-date2,'d')</STRONG></P><P></P><P></P><P></P><P><STRONG>Hope it help.<BR /></STRONG></P></BODY></HTML> Tue, 26 Feb 2013 10:06:08 GMT sujeetsingh 2013-02-26T10:06:08Z Conditional question https://community.qlik.com/t5/QlikView/Conditional-question/m-p/470288#M175628 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to build a filter with yes/no values. </P><P>The yes part is conditioned by:</P><P></P><P>For the same id (CNP&amp;SASIU) I can have multiple entries with start date(datainasg) and end date(dataoutasg).</P><P></P><P>If between 2 entries </P><P>dataoutasg(entry1) - datainasg(entry2) is 0 </P><P>and </P><P>dataoutasg(entry2) - datainasg(entry2) &gt;30, </P><P></P><P>then condition is true and the filter should show "yes", if not "No".</P><P></P><P>I am open to suggestions/solutions/opinions. </P><P></P><P>Thank you</P></BODY></HTML> Tue, 26 Feb 2013 09:08:56 GMT https://community.qlik.com/t5/QlikView/Conditional-question/m-p/470288#M175628 2013-02-26T09:08:56Z Re: Conditional question https://community.qlik.com/t5/QlikView/Conditional-question/m-p/470289#M175629 <HTML><HEAD></HEAD><BODY><P>Bogd ,</P><P>Try using just interval function in script</P><P></P><P><STRONG>interval(date1-date2,'d')</STRONG></P><P></P><P></P><P></P><P><STRONG>Hope it help.<BR /></STRONG></P></BODY></HTML> Tue, 26 Feb 2013 10:06:08 GMT https://community.qlik.com/t5/QlikView/Conditional-question/m-p/470289#M175629 sujeetsingh 2013-02-26T10:06:08Z