topic Re: min if expression in QlikView

min if expression

andreip21 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have multiple products with price history by every date.

Ex:

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

Ex:

Product	Certain Date	Period of 7 days	Min Price
1	06/28/2018	06/21/2018-06/27/2018	8
2	07/10/2018	03/07/2018 - 07/09/2018	29

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

thanks a lot in advance,

Andrei

its_anandrjs — Wed, 11 Jul 2018 11:20:26 GMT

Hi,

Use RangeSum() for this

Regards

Anand

sunny_talwar — Wed, 11 Jul 2018 11:35:04 GMT

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

andreip21 — Wed, 11 Jul 2018 11:35:57 GMT

certain date is another input (loaded file)

sunny_talwar — Wed, 11 Jul 2018 11:38:03 GMT

You can try this

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