topic Re: Difference between dimension limit and max Number in Presentation in straight table? in QlikView

Difference between dimension limit and max Number in Presentation in straight table?

Thu, 25 Sep 2014 12:35:09 GMT

Dear All,

Can anyone explain me what is the difference between writing the variable in "dimension limit" and "Max Number property in Presentation" of a straight table for displaying the top N items selected from a slider?

Thanks in advance

Debasmita Mitra

Re: Difference between dimension limit and max Number in Presentation in straight table?

deepakqlikview_123 — Thu, 25 Sep 2014 13:50:12 GMT

dimension limit tab is new functionality in QV 11.

helps to show top n /bottom n results.

May other member in community will able to explain abt max number,

thanks

Re: Difference between dimension limit and max Number in Presentation in straight table?

maxgro — Thu, 25 Sep 2014 21:24:54 GMT

max number:

display the first n rows (1..100) of a straigth table

you can choose the first rows sorting the columns you want

max number works only in str tables

dimension limit:

restrictions are always made using the first expression (in max number you can choose the expression)

dim limit has many more options: largest, smallest, greater than .... (see help for detail)

dim limit works in different charts (straigtht, bar, line, ...)

Re: Difference between dimension limit and max Number in Presentation in straight table?

Fri, 26 Sep 2014 04:37:54 GMT

Thanks a lot Massimo. It helped me a lot clarifying the confusion.

Re: Difference between dimension limit and max Number in Presentation in straight table?

Fri, 26 Sep 2014 06:14:53 GMT

Thanks.

Re: Difference between dimension limit and max Number in Presentation in straight table?

jagan — Fri, 26 Sep 2014 06:31:57 GMT

Hi,

With Dimension Limits you have many options

Largest N,

Smallest N,

Show values Greater Than,

Show values Lesser Than,

Show values Greater Than or Equal to>,

Show values Lesser Than or Equal to,

Total

Others

Accumulate to n%

This all are not possible with Presentation properties.

Hope this helps you.

Regards,

Jagan.