Time per euros

[Anonymous]

Hello everybody!

It´s a very simple question.

I need to calculate the amount of euros done per time.

1 minute is equal to 0,13333 euros.

So 10 minutes should be 1,3333 euros.

But when I do FieldTime*0,13333 it calculates the num(FieldTime)*0,13333 so, 0.0069*0.13333.

How can I do this?

Thank you

[Anonymous]

Hello!

I found the solution.

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.

With this, I have the total mins and I multiplie this amount with the euros.

If there is a better solution please let me know