topic Re: 2nd most highest value in QlikView

2nd most highest value

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

I want to create a an expression in the front end , that points to the 2nd last value.

So for example, in the simple list of dates below, I want to create say, Sum (Sales), but it where date = 20/03/2018

Date Sales

17/01/2018 20

14/02/2018 40

20/03/2018 10

06/04/2018 90

How do i do this?

Kind regards

Nayan

Re: 2nd most highest value

sunny_talwar — Tue, 10 Apr 2018 12:06:55 GMT

May be this

FirstSortedValue(Aggr(Sum(Sales), Date), -Date, 2)

Re: 2nd most highest value

nayanqlik — Tue, 10 Apr 2018 12:08:25 GMT

Thank you Sunny for the quick response. Will try and let you know.

Kind regards

Nayan

Re: 2nd most highest value

nayanqlik — Tue, 10 Apr 2018 12:20:04 GMT

Hi Sunny

Doesn't work out, not sure where I'm going wrong. If I just want to show the value in the date field only, so in my case , 20/03/2018

Re: 2nd most highest value

sunny_talwar — Tue, 10 Apr 2018 12:27:38 GMT

Show in date field? Not sure I understand?... would you be able to elaborate?

Re: 2nd most highest value

nayanqlik — Tue, 10 Apr 2018 12:57:29 GMT

I had a relook at my model and ignore my logic above. I'll resend you my query.

Kind regards

Nayan

Re: 2nd most highest value

jonathandienst — Tue, 10 Apr 2018 12:57:49 GMT

How about:

=Max(Date, 2)

=Date(Max(Date, 2))

Re: 2nd most highest value

Nagaraju_KCS — Tue, 10 Apr 2018 13:43:28 GMT

Try this..

=Date(Max(Date, 2),'DD/MM/YYYY')

=FirstSortedValue(Date, -Date, 2)

Re: 2nd most highest value

nayanqlik — Tue, 10 Apr 2018 13:49:36 GMT

Hi All

Thank you all for your reply. I need to relook at the script. I thought looking at the 2nd most highlest value would solve the actual issue I'm having.

If I get a solution, will share.

Kind regards

Nayan