Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is meant by dimension limits and rank function

pls send answer

4 Replies
robert_mika
Master III
Master III

Dimension Limits:

(Look at second tab in your Chart) but basically:

Dimension Limits can be set for chart types, except for Gauge Charts and Pivot Tables.

The Dimension Limits tab controls the number of dimension values you can see in a given chart.

Rank function

Evaluates expression, compares the result with the result of the other rows containing the current column segment and returns the ranking of the current row within the segment

(for more look at your Qlikview help)

Not applicable
Author

Both are ways to see data in particular ranks, from top or bottom.


Dimension limit is a new feature of Qlikview 11 release, you can basically limit your dimension to show top/bottom.. x records of your dimension.

Same thing you can achieve with Rank function like, rank(aggr(sum(sales),dimesnion value)<x.

You can see Qlikview reference manual for more detailed info.

Not applicable
Author

Dimensional Limit :They are used to define filters that establish how much information to return and how to organize it within a chart.

Rank Function: Rank() function helps to display TOP/BOTTOM N values in either Ascending/Descending Order in QlikView reports.

Not applicable
Author

HI,

Dimension limits:

One of the common business requirements when analyzing the data is limiting the dimension values on a chart. For instance, limiting the chart to the top 10 sales people, or showing only the products that make up 80% of sales. Qlikview 11 dimension limits functionality enables the business users to easily create these logics on the charts.

Rank:

rank([ total ] expression [ , mode [, format ] ])

Evaluates expression, compares the result with the result of the other rows containing the current column segment

and returns the ranking of the current row within the segment.