Hi,
Have a small problem, I need to calculate the minimum values of the dataset corresponding to the value as of today. Let me explain with an example
| Date | Value | Min Value |
| 1 | 101 | |
| 2 | 110 | 105 |
| 3 | 105 | |
| 4 | 109 | |
| 5 | 115 | 109 |
| 6 | 117 | 109 |
| 7 | 109 | |
| 8 | 120 | 111 |
| 9 | 111 | |
| 10 | 130 | |
On Day 1 the value is 101 and there is no value lesser than 101, so min value is blank.
On Day 2 the value is 110 and for the remaining period the min value is 105, so selected Min Value is 105
On Day 3 the value is 105 and for the remaining period the min value is 105, so Min Value is blank
Similarly on Day 5 the value is 115 and for the remaining period the min value is 109, so selected Min Value is 109
How to get such values in QV?
