Hi,
I'm new to Qlickview and I need to add a columns to the table loaded that has calculated minimum value each time a variable change. MinVal, StartDate column below is what i'm looking for. MinVal stores minimum VALUE for each corresponding NAME. StartDate stores first date with value corresponding to the NAME. Thank you for your help.
| NAME | DATE | VALUE | MinVal | StartDate |
| A | 1/1/2019 | | 1.00 | 2/1/2019 |
| A | 2/1/2019 | 1.00 | 1.00 | 2/1/2019 |
| A | 3/1/2019 | 2.00 | 1.00 | 2/1/2019 |
| B | 1/1/2019 | 5.00 | 5.00 | 1/1/2019 |
| B | 2/1/2019 | 6.00 | 5.00 | 1/1/2019 |
| C | 3/1/2019 | 3.00 | 3.00 | 3/1/2019 |
| C | 4/1/2019 | 4.00 | 3.00 | 3/1/2019 |
| C | 5/1/2019 | 5.00 | 3.00 | 3/1/2019 |
