Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
apalmtree
Creator II
Creator II

second max value

Hi!

Do i have to sort my tables in order to get the second next highest date for example? or is it another way?

1 Solution

Accepted Solutions
TigerisBack
Champion
Champion

max(filedname,2)

hope this help

View solution in original post

6 Replies
Not applicable

Hi,

if you want highlight that you can use some one of the "rank" function in your table.

C u,

Stefano

TigerisBack
Champion
Champion

max(filedname,2)

hope this help

View solution in original post

apalmtree
Creator II
Creator II
Author

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.

Not applicable

Why don't use two max together?

something like this: max(filedname,2) + max(filedname) in combination with aggr function also.

C u,

Stefano.

TigerisBack
Champion
Champion

see the attached file

hope this helps you

apalmtree
Creator II
Creator II
Author

Hi guys.

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!

Thanks!