topic Re: Second max value in title in QlikView

Second max value in title

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to shwo the second max value in the title.

To get the dimension, i've :

=Only(if(aggr(

Rank(Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )

Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )

,Revenu_T1

),Revenu_T1)

=2,Revenu_T1))

that's fine, but i also want the value ...

I tried many things but without success ...

pick(2,

Rank( (Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )

Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) ))

,Revenu_T1 ) )

thanks for your help.

olivierrobin — Wed, 16 May 2018 10:00:29 GMT

hello

tou could try to use

FirstSortedValue()

FirstSortedValue ([ distinct ] value, sort-weight [, rank ])

and specifying rank as 2

sunny_talwar — Wed, 16 May 2018 11:05:51 GMT

How about this

=Max(Aggr(

Count(If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))/

Count(TOTAL If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))

, Revenu_T1), 2)

sagar_puri — Wed, 16 May 2018 11:11:21 GMT

Hi,

Try max(filedname,2)

hope this helps

Anonymous — Wed, 16 May 2018 11:52:47 GMT

Thanks Sunny, that's right !!!!

Anonymous — Wed, 16 May 2018 11:53:18 GMT

i tried it but unsuccessfully

bc-thebruuu — Wed, 16 May 2018 11:56:54 GMT

Can you provide sample data or sample application to work on?