Discussion Board for collaboration related to QlikView App Development.
Hope you are doing good.
I have to display the first year where sale is less than the sale in the first row.
Here USA is the first whose sale is less than sale in the First row (i.e 250 < 500).
Hence my solution should be 2014.
Thanks a lot in advance.
Just to note that above uses LOAD order as sort order.
And you might run into troubles if you have YEAR values appear more than once (because of the use of Only() ), like shown for year 2016 in your sample data.