topic Time per euros in QlikView https://community.qlik.com/t5/QlikView/Time-per-euros/m-p/1189137#M885537 <HTML><HEAD></HEAD><BODY><P>Hello everybody!</P><P></P><P>It´s a very simple question.</P><P></P><P>I need to calculate the amount of euros done per time.</P><P></P><P>1 minute is equal to 0,13333 euros.</P><P></P><P>So 10 minutes should be 1,3333 euros.</P><P></P><P>But when I do FieldTime*0,13333 it calculates the num(FieldTime)*0,13333 so, 0.0069*0.13333.</P><P></P><P>How can I do this?</P><P></P><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Time per euros https://community.qlik.com/t5/QlikView/Time-per-euros/m-p/1189137#M885537 <HTML><HEAD></HEAD><BODY><P>Hello everybody!</P><P></P><P>It´s a very simple question.</P><P></P><P>I need to calculate the amount of euros done per time.</P><P></P><P>1 minute is equal to 0,13333 euros.</P><P></P><P>So 10 minutes should be 1,3333 euros.</P><P></P><P>But when I do FieldTime*0,13333 it calculates the num(FieldTime)*0,13333 so, 0.0069*0.13333.</P><P></P><P>How can I do this?</P><P></P><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Time-per-euros/m-p/1189137#M885537 Anonymous 2020-11-25T16:16:04Z Re: Time per euros https://community.qlik.com/t5/QlikView/Time-per-euros/m-p/1189138#M885538 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I found the solution.</P><P></P><P>In fact, qlik convert the time in a number. So I had just to take this number an multiplie it by minuts in a day, so 1440.</P><P>With this, I have the total mins and I multiplie this amount with the euros.</P><P></P><P>If there is a better solution please let me know <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Sep 2016 05:28:14 GMT https://community.qlik.com/t5/QlikView/Time-per-euros/m-p/1189138#M885538 Anonymous 2016-09-22T05:28:14Z