topic Dynamic calculation in QlikView https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181943#M47785 <HTML><HEAD></HEAD><BODY><P>I would like to se the time for any 5k interval for any run.</P></BODY></HTML> Tue, 25 Jan 2011 14:35:05 GMT jakob_hansen 2011-01-25T14:35:05Z Dynamic calculation https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181940#M47782 <HTML><HEAD></HEAD><BODY><P>I got this table who contain lap info of my running. I would like to find the fastest 5k of any run. How can I do that?</P><P></P><P>E.g if i ran 8k i would like to calculate the time used for 1-5km, 2-6km 3-7km, 4-8km and rank then by the time used.</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3329_sourceID:3329" /></P></BODY></HTML> Mon, 24 Jan 2011 14:49:57 GMT https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181940#M47782 jakob_hansen 2011-01-24T14:49:57Z Dynamic calculation https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181941#M47783 <HTML><HEAD></HEAD><BODY><P>Show the result data which you would expect to see.</P></BODY></HTML> Mon, 24 Jan 2011 16:22:13 GMT https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181941#M47783 2011-01-24T16:22:13Z Dynamic calculation https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181942#M47784 <HTML><HEAD></HEAD><BODY><P>Jakob,</P><P>Attached isn't the complete and polished solution but it should start you on the right path (running track!?).</P><P>Essentially I'm using the rangesum function to show for each Mile how long it took to complete that mile and the next 4 (making 5 in total) thus allowing you to see which group of 5 took the shortest amount of time.</P><P>With some slight changes you should be able to isolate the date (run) as well making it do as you require.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Mon, 24 Jan 2011 16:47:53 GMT https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181942#M47784 matt_crowther 2011-01-24T16:47:53Z Dynamic calculation https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181943#M47785 <HTML><HEAD></HEAD><BODY><P>I would like to se the time for any 5k interval for any run.</P></BODY></HTML> Tue, 25 Jan 2011 14:35:05 GMT https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181943#M47785 jakob_hansen 2011-01-25T14:35:05Z Dynamic calculation https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181944#M47786 <HTML><HEAD></HEAD><BODY><P>I made this code in the chart and it seems to work...</P><P></P><P></P><P></P><P>if</P><P></P><P>(rangesum(Below(Distance,0,5))=5000, time((rangesum(Below(Minutes,0,5)))/1440,'h:mm:ss'))</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 25 Jan 2011 14:42:42 GMT https://community.qlik.com/t5/QlikView/Dynamic-calculation/m-p/181944#M47786 jakob_hansen 2011-01-25T14:42:42Z