topic Re: Dimension limit in QlikView

Dimension limit

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

what is dimension limit and rank function in qlickview with real time examles ?

Re: Dimension limit

awhitfield — Thu, 04 May 2017 14:52:35 GMT

Have you looked in the Qlik Help?

Andy

Re: Dimension limit

Sergey_Shuklin — Mon, 08 May 2017 07:51:08 GMT

Hi, Ramesh!

Dimension Limits can only be used for charts.This parameter reduce the number of showed bars/lines/dots etc.

A Rank function defines an order of field values. For instance "rank(sum(sales))" will mark from 1 to n all amounts of sum(sales) in pivot table. If you use more than one dimension in pivot table you must specify rank calculating level using a Dimensionality() function.

Re: Dimension limit

Siva_Sankar — Mon, 08 May 2017 08:14:21 GMT

Ramesh,

Check here what is meant by dimension limits and rank function and

why dimension limits and rank in qk11? | Qlik Community

Siva

Re: Dimension limit

Anonymous — Mon, 08 May 2017 08:36:54 GMT

Dimension limit can use in charts where as rank function will use in pivot table. We dont have dimension limit option in Pivot table. For example Top 5 Customers, Top N products etc. Depends on situation will use dimension limit and rank functions.