topic Time elappsed in QlikView https://community.qlik.com/t5/QlikView/Time-elappsed/m-p/1457361#M797107 <HTML><HEAD></HEAD><BODY><P>Dear All ,</P><P></P><P>I need to calculate Time Elapsed Quarterly , I am currently calculated Daily as follow :</P><P><SPAN style="font-size: 10pt;"><STRONG>vTimeElapsed</STRONG>: (((</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">DayNumberOfYear</SPAN><SPAN style="font-size: 10pt;">(num(Today()) )-1)/365*100)-1 . </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I want to Calculate the time elapsed in the script QUARTERLY since my score is a Quarterly score, </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Some KPIs has a percentage VS Time elapsed % and are calculated quarterly. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Can you help me to calculate <STRONG style="font-size: 10pt;">vTimeElapsed</STRONG> as Quarterly since I need to save it as quarterly</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Exemple&nbsp; : Q1 as end of March = 23.7% , Q2 as End of Juin...</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you, </SPAN></P><P><SPAN style="font-size: 10pt;">hope you can help.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mario-sarkis 2020-11-25T16:16:04Z Time elappsed https://community.qlik.com/t5/QlikView/Time-elappsed/m-p/1457361#M797107 <HTML><HEAD></HEAD><BODY><P>Dear All ,</P><P></P><P>I need to calculate Time Elapsed Quarterly , I am currently calculated Daily as follow :</P><P><SPAN style="font-size: 10pt;"><STRONG>vTimeElapsed</STRONG>: (((</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">DayNumberOfYear</SPAN><SPAN style="font-size: 10pt;">(num(Today()) )-1)/365*100)-1 . </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I want to Calculate the time elapsed in the script QUARTERLY since my score is a Quarterly score, </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Some KPIs has a percentage VS Time elapsed % and are calculated quarterly. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Can you help me to calculate <STRONG style="font-size: 10pt;">vTimeElapsed</STRONG> as Quarterly since I need to save it as quarterly</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Exemple&nbsp; : Q1 as end of March = 23.7% , Q2 as End of Juin...</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you, </SPAN></P><P><SPAN style="font-size: 10pt;">hope you can help.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Time-elappsed/m-p/1457361#M797107 mario-sarkis 2020-11-25T16:16:04Z Re: Time elappsed https://community.qlik.com/t5/QlikView/Time-elappsed/m-p/1457362#M797109 <HTML><HEAD></HEAD><BODY><P>There is a function called DayNumberOfQuarter... may be you need that instead of DayNumberOfYear?</P></BODY></HTML> Tue, 02 Jan 2018 09:48:52 GMT https://community.qlik.com/t5/QlikView/Time-elappsed/m-p/1457362#M797109 sunny_talwar 2018-01-02T09:48:52Z