Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Price calculation (time based)

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.

Forum.png

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

but is the right result 6.1?

I hope my file is correct..

C u,

Stefano

View solution in original post

3 Replies
Not applicable
Author

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

Not applicable
Author

Hi,

but is the right result 6.1?

I hope my file is correct..

C u,

Stefano

Not applicable
Author

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