topic Re: Rank in QlikView

Rank

varunreddy — Wed, 26 Oct 2016 18:13:21 GMT

Hi,

I am trying to get the records where the rank is 1 and exclude all other filters.

Expression I am using is:

only({<[Observation/Report Date Summary] = {"=rank([Observation/Report Date Summary])=1"}>}[Observation/Report Date Summary])

Attached is the sample data set.

Can anyone guide me with this?

Thanks in advance!

Cheers,

Varun

Re: Rank

sunny_talwar — Wed, 26 Oct 2016 18:15:46 GMT

Rank of Date? Is that a field or is that something you are calculating?

Re: Rank

varunreddy — Wed, 26 Oct 2016 18:19:46 GMT

Process ID is one field and Date is one field. For some ID's I have one date and for others I have muktiple. Now I want the ID's with latest date if we have multiple dates, else we need the ID's.

So I am calculating rank(Date) and trying to pull with rank =1.

Did this explanation work?

Re: Rank

varunreddy — Wed, 26 Oct 2016 18:21:15 GMT

This is what I obtain. Now I want the ID's where rank is 1. third column here is calculated.

i.e. Rank(Date)

Re: Rank

sunny_talwar — Wed, 26 Oct 2016 18:22:34 GMT

May be like this:

Aggr(If(Rank([Observation/Report Date Summary]) < 2, [Observation/Report Date Summary]), [Process ID], [Observation/Report Date Summary])

Re: Rank

varunreddy — Wed, 26 Oct 2016 18:29:58 GMT

Thanks Sunny