Discussion Board for collaboration related to QlikView App Development.
Do i have to sort my tables in order to get the second next highest date for example? or is it another way?
hope this help
View solution in original post
if you want highlight that you can use some one of the "rank" function in your table.
sorry that's not what i'm looking for. i have to be able to use it in an expression i order to compare max and second max value.
Why don't use two max together?
something like this: max(filedname,2) + max(filedname) in combination with aggr function also.
see the attached file
hope this helps you
You we're right, i was wrong. Max(date,2) worked perfectly! (i didn't have enough data to do it, that was it)
sorry for troubling you!