topic Re: Price calculation (time based) in QlikView

Price calculation (time based)

Thu, 08 Sep 2011 13:21:13 GMT

Hello,

Can someone tell me how much the total price of my shopping cart is?

I went shopping 5 times, and I bought either apples or bananas.

The only difficulty is that the price depends on the time the product was bought.

I would like to be able to display the total amount in a text field.

Thanks for your help!!

Ps: This is the simplied version of a previous question (which was too complex). Therefore I narrowed it down to a very easy to understand example 🙂 Hope that helps.

Kind regards,

Maarten

Price calculation (time based)

Thu, 15 Sep 2011 13:29:37 GMT

Really nobody who can help me out to tell me how much my 4 bananas and 1 apple cost? 🙂

Re: Price calculation (time based)

Thu, 15 Sep 2011 18:33:09 GMT

Hi,

but is the right result 6.1?

I hope my file is correct..

C u,

Stefano

Re: Price calculation (time based)

Fri, 16 Sep 2011 06:11:26 GMT

Wonderful!

Thanks a lot Stefano, that is indeed the correct outcome!

Yeah, something went wrong in my head (1x1=4? 🙂 --> Obviously this needed to be 1, resulting indeed in a total sum of 6.1).

You did the job, and made me very happy!

Thanks again!

Ps: now I need to apply this on a larger scale, with more time dependant factors, but this was what I needed.

Kind regards,

Maarten