Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hari8088
Creator
Creator

top 4th result

Hi to experts,

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

9 Replies
robert_mika

Like this:

28-Apr-15 9-34-35 AM.jpg

MK_QSL
MVP
MVP

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

ankitaag
Partner
Partner

Hi,

Please clearify

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

anbu1984
Master III
Master III

Fourth highest customer

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

hari8088
Creator
Creator
Author

Hi.

4th highest among all

MK_QSL
MVP
MVP

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

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

Not applicable

Hi,

Please try this expression

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

Chanty4u
Champion III
Champion III

Not applicable

try this

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