topic Re: what is meant by dimension limits and rank function!!!!!!!! in QlikView

what is meant by dimension limits and rank function

Wed, 03 Jun 2015 04:58:14 GMT

pls send answer

Re: what is meant by dimension limits and rank function!!!!!!!!

robert_mika — Wed, 03 Jun 2015 05:02:32 GMT

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)

Re: what is meant by dimension limits and rank function

Wed, 03 Jun 2015 05:22:09 GMT

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.

Re: what is meant by dimension limits and rank function!!!!!!!!

Wed, 03 Jun 2015 05:24:40 GMT

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.

Re: what is meant by dimension limits and rank function

Wed, 03 Jun 2015 06:11:24 GMT

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.