topic Re: syntax in QlikView

syntax

Thu, 04 Sep 2014 10:12:50 GMT

is their any syntax to get top values

say top 5 from a lot of 50

if yes what is it

thanks'

Re: syntax

michael_maeuser — Thu, 04 Sep 2014 10:15:53 GMT

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

hope that helps

Re: syntax

sushil353 — Thu, 04 Sep 2014 10:16:07 GMT

Use rank function in dimension..

or you can use dimension limit option.

Re: syntax

tresB — Thu, 04 Sep 2014 10:24:24 GMT

See: Top 10 Rank and Dimension Limits?

Re: syntax

ashwanin — Thu, 04 Sep 2014 10:26:32 GMT

Hi Deepak,

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

Re: Top 10 With Total

Re: syntax

maleksafa — Thu, 04 Sep 2014 10:29:24 GMT

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...

Re: syntax

ashfaq_haseeb — Thu, 04 Sep 2014 10:31:09 GMT

Have a look at attached application.

Regards

ASHFAQ

Re: syntax

Thu, 04 Sep 2014 10:34:44 GMT

whats exactly the syntax for rank function..

say i need top 3 values

Re: syntax

ashfaq_haseeb — Thu, 04 Sep 2014 10:37:27 GMT

Hi,

Look at my application attached in my previous post.

Regards

ASHFAQ

Re: syntax

MayilVahanan — Thu, 04 Sep 2014 10:38:50 GMT

Try like this

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

Re: syntax

MK_QSL — Thu, 04 Sep 2014 11:10:23 GMT

Consider that you have below script...

Sales:

Load * Inline

[

Customer, Sales

A, 100

B, 120

C, 200

D, 90

E, 45

F, 65

G, 150

H, 200

I, 100

J, 150

];

There are multiple ways to get TOP 5...

1) TOP 5 - Dimension Limit

Create a Straight Table

Dimension

Customer

Expression

SUM(Sales)

Dimension Limit

Tick Restrict which values are displayed using the first expression

Show Only Largest 5 Values

2) Sales - TOP 5 Calculated Dimension

Create a Straight Table

Dimension - Use Calculated Dimension

=IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Customer)

Expression

SUM(Sales)

3) TOP 5 - Set Analysis

Create a Straight Table

Dimension

Customer

Expression

SUM({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales)