Text Object expression

[sk88024]

I am new to Qlikview and struggling to get below expressions in Text object.

1. To get the second lowest profit

2. to get the total profits till previous year( where 2019 is the current year)

The data set would be like this:

LOAD * INLINE [
Year, Profit
2012, 1000
2017, 3200
2018, 400
2019, 2000
];

[Anil_Babu_Samineni]

Perhaps these

1) Min(Profit,2)
2) Sum({<Year={">=$(=AddYears(Max(Year),-1))<=$(=Max(Year))"}>} Profit)

[sunny_talwar · Accepted solution]

I think for 2, it should be

Sum({<Year = {"<=$(=Year(Today())-1)"}>} Profit)