Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

syntax

is their any syntax to get top values

say top 5 from a lot of 50

if yes what is it

thanks'

10 Replies
michael_maeuser
Creator III
Creator III

in frontend, try rank function or take a look at the dimension limits tab in chart properties (only straight table).

hope that helps

sushil353
Master II
Master II

Use rank function in dimension..

or you can use dimension limit option.

tresesco
MVP
MVP

ashwanin
Specialist
Specialist

Hi Deepak,

Hope below thread help you to find the answer with sample qvw of rank function.

Re: Top 10 With Total

maleksafa
Specialist
Specialist

you can use the Rank function for exampel rank(sum(sales)) or use the dimension limits tab, where you will define to show the top 10 or least 10 etc...

ashfaq_haseeb

Have a look at attached application.

Regards

ASHFAQ

Not applicable
Author

whats exactly the syntax for rank function..

say i need top 3 values

ashfaq_haseeb

Hi,

Look at my application attached in my previous post.

Regards

ASHFAQ

MayilVahanan

Hi

Try like this

Sum({<Product = {"=rank(sum(Sales))<= 3"}>} Sales)

Thanks & Regards,
Mayil Vahanan R