topic Re: top 4th result in QlikView

top 4th result

hari8088 — Tue, 28 Apr 2015 07:58:55 GMT

Hi to experts,

I have 10 records now i want top 4th record how to write a set expression for that?

robert_mika — Tue, 28 Apr 2015 08:35:10 GMT

Like this:

MK_QSL — Tue, 28 Apr 2015 08:42:31 GMT

Max(Aggr(SUM(Sales),Customer),4)

ankitaag — Tue, 28 Apr 2015 09:13:22 GMT

Hi,

Please clearify

top 4th reult means 4th Row or 4th highest among all

anbu1984 — Tue, 28 Apr 2015 09:14:40 GMT

Fourth highest customer

=If(Rank(Aggr(SUM(Sales),Customer))=4,Customer)

hari8088 — Tue, 28 Apr 2015 09:27:52 GMT

Hi.

4th highest among all

MK_QSL — Tue, 28 Apr 2015 11:05:20 GMT

If you want Customer having 4th Highest Value, you need to use as below

=FirstSortedValue(Customer, -Aggr(SUM(Sales),Customer),4)

Wed, 16 Mar 2016 12:17:33 GMT

Hi,

Please try this expression

If(aggr(rank(SUM(Sales),Customer))=4,Customer)

Chanty4u — Thu, 17 Mar 2016 06:21:47 GMT

samples

Thu, 17 Mar 2016 07:06:08 GMT

try this

if(aggr(rank(expression),dimension)<=4,dimension)