topic second max value in QlikView

second max value

Anonymous — Thu, 15 Sep 2011 11:52:42 GMT

Hi!

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

second max value

Thu, 15 Sep 2011 12:11:49 GMT

Hi,

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

C u,

Stefano

second max value

SunilChauhan — Thu, 15 Sep 2011 12:13:22 GMT

max(filedname,2)

hope this help

second max value

Anonymous — Thu, 15 Sep 2011 12:32:42 GMT

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.

Re: second max value

Thu, 15 Sep 2011 12:40:16 GMT

Why don't use two max together?

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

C u,

Stefano.

Re: second max value

SunilChauhan — Thu, 15 Sep 2011 12:49:50 GMT

see the attached file

hope this helps you

second max value

Anonymous — Thu, 15 Sep 2011 13:43:19 GMT

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!

Re: second max value

andries_bos — Thu, 30 Mar 2023 07:58:05 GMT

max(filedname,2) does work indeeed, but I'm looking for a neat and easy solution in an expression the show all values >= the 12th last values : e.g. in an overvue show the values for the last 12 months.

This will do the trick = {'>=$(=Max(fieldname, 12))'} if there are more than 12 values available, but fails of there are only 4 values. It shows nothing...

Expression is = sum( {$< period = {'>=$(=Max(period,12))'} >} valuename )

I've came up with a solution to extra calc all distinct values and use the min() :

= sum( {$< per = {'>=$(=Max(period, min(count( distinct period), 12) ))'} >} valuename ) , but maybe there another easier solution?