topic help expression in QlikView https://community.qlik.com/t5/QlikView/help-expression/m-p/933817#M967423 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #575757;">Could someone help with this - it works - but i need it to calculate the percentage of </SPAN><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #575757;">MinAnaesthetistStart times that started within 10 minutes of the <SPAN style="font-size: 8pt;">MinSessionStart </SPAN>but include all those that started <SPAN style="color: #333333;">before the</SPAN></SPAN><SPAN style="color: #333333; font-size: 8pt;"> <SPAN style="font-size: 8pt;">MinSessionStart?&nbsp; </SPAN></SPAN></SPAN></SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">OperationOrder</SPAN><SPAN style="font-size: 8pt;">={1},</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinAnaesthetistStart</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;&gt;''"</SPAN><SPAN style="font-size: 8pt;">}&gt;}&nbsp; {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CancelledOnDay</SPAN><SPAN style="font-size: 8pt;">={0}&gt;} <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">frac</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinAnaesthetistStart</SPAN><SPAN style="font-size: 8pt;">) &lt;&nbsp; (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">frac</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinSessionStart</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">interval#</SPAN><SPAN style="font-size: 8pt;">('0:10','h:mm')),1,0))/ <BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">{&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SessionUsed</SPAN><SPAN style="font-size: 8pt;">={1}&gt;}&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SessionID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Thu, 24 Sep 2015 15:12:26 GMT qliklizzy 2015-09-24T15:12:26Z help expression https://community.qlik.com/t5/QlikView/help-expression/m-p/933817#M967423 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #575757;">Could someone help with this - it works - but i need it to calculate the percentage of </SPAN><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #575757;">MinAnaesthetistStart times that started within 10 minutes of the <SPAN style="font-size: 8pt;">MinSessionStart </SPAN>but include all those that started <SPAN style="color: #333333;">before the</SPAN></SPAN><SPAN style="color: #333333; font-size: 8pt;"> <SPAN style="font-size: 8pt;">MinSessionStart?&nbsp; </SPAN></SPAN></SPAN></SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">OperationOrder</SPAN><SPAN style="font-size: 8pt;">={1},</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinAnaesthetistStart</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;&gt;''"</SPAN><SPAN style="font-size: 8pt;">}&gt;}&nbsp; {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CancelledOnDay</SPAN><SPAN style="font-size: 8pt;">={0}&gt;} <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">frac</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinAnaesthetistStart</SPAN><SPAN style="font-size: 8pt;">) &lt;&nbsp; (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">frac</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MinSessionStart</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">interval#</SPAN><SPAN style="font-size: 8pt;">('0:10','h:mm')),1,0))/ <BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">{&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SessionUsed</SPAN><SPAN style="font-size: 8pt;">={1}&gt;}&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SessionID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Thu, 24 Sep 2015 15:12:26 GMT https://community.qlik.com/t5/QlikView/help-expression/m-p/933817#M967423 qliklizzy 2015-09-24T15:12:26Z