How to get second max value from result of aggr function

[#1]

Hi,

I'm new to qlikview,

Am looking to find second max value from result of aggr function

Here I attached the query ,

From this expression i need second max value

Regards,

UdaYeah

[sunny_talwar]

May be this:

Max(Aggr(Count(Empp_ID), Technology, 2)

[#3]

Thank you sunny am getting ans as i expected.....

Regards,

Udayeah

[sunny_talwar]

Awesome, please close this thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[#5]

Sunny,

I don't know how to do that, i can't find that option

Regards,

Udayeah

[sunny_talwar]

Did you look at the link I provided, it provide all the details on how you can mark correct and helpful responses