topic Dimension limits in a Chart ? in QlikView

Dimension limits in a Chart ?

Sat, 15 Mar 2014 00:27:31 GMT

In a bar chart, there are 3 choices under dimension limits, when "Restrict which values are displayed using the first expression" -
1) "Show only" :: First, Largest,Smallest :: x values

2) "Show only values that are" :: Greater than, Less than, Greater than or equal to, or Less than or equal a value.

3) "Show only values that accumulate to" ...

What is the meaning of 2 and 3 ?

Re: Dimension limits in a Chart ?

datanibbler — Sat, 15 Mar 2014 08:33:22 GMT

Hi John,

just read all there is to seee in the dialog.

2) "Show values that are {individually} [greater than] [x%] ... of total sum"

=> Only values that are individually (e.g.) greater than 5% of your total will be shown

3) "Accumulation of values" ... [relative to total sum]

=> Only just so many values will be shown until (e.g.) 80% of your total are reached.

=> In both cases, there are so many options with the two dropdown menus, it's like Starbucks' "chochochino latte grande creamy decaf" - I cannot tell you exactly what you'll get when selecting any combination, just try it out.

HTH

Best regards,

DataNibbler

Re: Dimension limits in a Chart ?

maxgro — Sat, 15 Mar 2014 09:19:31 GMT

from online help

Show only values that are:

Select this option to display all dimensions values that meet the specified condition for this option. Select to display values based on a percentage of the total, or on an exact amount. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog. The value may be entered as a calculated formula. Click on the ... button to open the Edit Expression Dialog.

Show only values that accumulate to:

When this option is selected,all rows up to the current row are accumulated, and the result is compared to the value set in the option. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog, and compares the accumulated values (based on first, largest or smallest values) to the overall total. The value may be entered as a calculated formula. Click on the ... button to open the Edit Expression Dialog. Select Include Boundary Values to include the dimension value that contains the comparison value.

Note!

Negative values will not be included when calculating the accumulated restriction sum. We recommend that you don't use relative restrictions for fields that can contain negative values.

or see attachment

Re: Dimension limits in a Chart ?

Sun, 16 Mar 2014 23:16:40 GMT

thanks. Please put the attachment.

Re: Dimension limits in a Chart ?

Wed, 02 Dec 2015 12:57:13 GMT

Hi , can you apply this to only show the last 3 months in a year

Re: Dimension limits in a Chart ?

maxgro — Wed, 02 Dec 2015 19:45:35 GMT

last = smallest?

Re: Dimension limits in a Chart ?

ttomasz_pl — Wed, 15 Mar 2017 07:26:50 GMT

Hi,

And is there any "elegant" way to limt 3 months back from current and 10 months forward?

Re: Dimension limits in a Chart ?

satyansss — Sun, 03 Jun 2018 12:22:06 GMT

The difference between the second and the third options is that the former evaluates

the individual result corresponding to the dimension's value, while the latter

evaluates the cumulative total of that value by either sweeping from largest to

smallest or vice versa. This can be used, for instance, in a Pareto analysis