Time Series: lowest value x time

[brunodgarcia]

Hi,

I have data in the following format:

Time     Company     Value

1          A                    100

1          B                    90

2          A                    95

3          A                    85

4          B                    86

I'd like to show a chart with the minimum value in time, like this:

Time     Value

1          90

2          90

3          85

4          85

I need to calculate the lowest value considering only the ones that have the time dimension smaller than the current line.

How can I do that in Qlikview?

Thanks for you help!

[sunny_talwar · Accepted solution]

May be this

RangeMin(Above(Min(Value), 0, RowNo()))

[brunodgarcia]

Perfect! Thanks a lot!