Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andreip21
Contributor III
Contributor III

min if expression

Hi all,

i have multiple products with price history by every date.

Ex:

ProductDatePrice
106/25/201810
106/26/201810
106/27/20188
207/02/201825
207/03/201829
207/04/201829

I want to calculate the minimum price for each product for a period of 7 days before a certain date:

Ex:

ProductCertain DatePeriod of 7 daysMin Price
106/28/201806/21/2018-06/27/20188
207/10/201803/07/2018 - 07/09/201829

If it's possible, i want to calculate directly in a chart.

thanks a lot in advance,

Andrei

1 Solution

Accepted Solutions
sunny_talwar

You can try this

Min(If(Date >= [Certain Date] - 7 and Date < [Certain Date], Price))

View solution in original post

4 Replies
its_anandrjs

Hi,

Use RangeSum() for this

Regards

Anand

sunny_talwar

How is Certain Date determined in the example you gave above?

andreip21
Contributor III
Contributor III
Author

certain date is another input (loaded file)

sunny_talwar

You can try this

Min(If(Date >= [Certain Date] - 7 and Date < [Certain Date], Price))