topic Re: sql expression in qlikview in QlikView https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018375#M942988 <HTML><HEAD></HEAD><BODY><P>Run time: interval(sum(time)/24/60,'hh:mm')</P></BODY></HTML> Tue, 26 Jan 2016 16:39:44 GMT 2016-01-26T16:39:44Z sql expression in qlikview https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018373#M942986 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>i have the below expressions in sql.</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"><STRONG>Drops% =Fields!Drops.Value/Sum(Fields!Drops.Value, <SPAN style="color: #a31515;">"Driver"</SPAN>)</STRONG></SPAN></P><P><STRONG style="font-size: 10.0pt; font-family: 'Courier New';"><BR /></STRONG></P><P><STRONG>Run Time :&nbsp; <SPAN style="font-size: 10.0pt; font-family: 'Courier New';">= (</SPAN></STRONG></P><P><STRONG style="font-size: 10.0pt; font-family: 'Courier New';">IIF(Fields!Time.Value\60 &lt; 10, <SPAN style="color: #a31515;">"0"</SPAN> + CStr(Fields!Time.Value\60), CStr(Fields!Time.Value\60)) </STRONG></P><P><STRONG style="font-size: 10.0pt; font-family: 'Courier New';"> + <SPAN style="color: #a31515;">":"</SPAN> + </STRONG></P><P><STRONG style="font-size: 10.0pt; font-family: 'Courier New';"> IIF(Fields!Time.Value <SPAN style="color: blue;">mod</SPAN> 60 &lt; 10, <SPAN style="color: #a31515;">"0"</SPAN> + FormatNumber(Fields!Time.Value <SPAN style="color: blue;">mod</SPAN> 60,0), FormatNumber(Fields!Time.Value <SPAN style="color: blue;">mod</SPAN> 60,0))</STRONG></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"><STRONG>)</STRONG></SPAN></P><P></P><P></P><P>In Qlikview, Drops is calculated as below</P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Drops: sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">DISTINCT</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">customer</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">ORDERNO</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="color: black; font-size: 9.0pt; font-family: arial, helvetica, sans-serif;">how can i calculate above (sql) <STRONG style="font-size: 13.3333px; font-family: arial, helvetica, sans-serif;">Drops% &amp; Run Time in qlikview.</STRONG></SPAN></P><P><SPAN style="font-size: 9pt; font-family: arial, helvetica, sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-family: arial, helvetica, sans-serif;">Please help</SPAN><BR /></SPAN></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018373#M942986 2020-11-20T18:02:30Z Re: sql expression in qlikview https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018374#M942987 <HTML><HEAD></HEAD><BODY><P>Run Time: Time(Fields!Time.Value/86400, 'mm:ss')</P></BODY></HTML> Mon, 18 Jan 2016 18:14:02 GMT https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018374#M942987 Gysbert_Wassenaar 2016-01-18T18:14:02Z Re: sql expression in qlikview https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018375#M942988 <HTML><HEAD></HEAD><BODY><P>Run time: interval(sum(time)/24/60,'hh:mm')</P></BODY></HTML> Tue, 26 Jan 2016 16:39:44 GMT https://community.qlik.com/t5/QlikView/sql-expression-in-qlikview/m-p/1018375#M942988 2016-01-26T16:39:44Z