topic Re: min and max price date range in QlikView

min and max price date range

Wed, 24 Jun 2015 18:42:22 GMT

Hi experts

I do have a requirement where I need to show current price, previous day price, min price (10 day ), max price (10 Day).

please see sample data

so, if select June 19 o/p table should look

so, if select June 18 o/p table should look

Product Id	Current Price	Previous Day Price	Min Price (10 Days)	max Price (10 Days)
ABC1234	82	83	72	91

please help

sunny_talwar — Wed, 24 Jun 2015 19:53:58 GMT

PFA.

Best,

Sunny

maxgro — Wed, 24 Jun 2015 19:54:18 GMT

only({$ <BusinessDate={"$(=date(max(BusinessDate)-1))"}>} Price)

min({$ <BusinessDate={">=$(=date(max(BusinessDate)-11))<=$(=date(max(BusinessDate)))"}>} Price)

max({$ <BusinessDate={">=$(=date(max(BusinessDate)-11))<=$(=date(max(BusinessDate)))"}>} Price)

Clever_Anjos — Wed, 24 Jun 2015 19:56:27 GMT

Please find attached

Wed, 24 Jun 2015 20:38:05 GMT

Thx Massimo I think this formula is working, but can you let me know how to exlcude weekends in the range. Thanks for the help.

Wed, 24 Jun 2015 20:40:54 GMT

Hi Sunindia,

can you let me know the logic how this formula works, when I try to implement I'm getting blank values.

Thx for help