topic Re: Tutorial Help - Limiting the number of bars in QlikView

Tutorial Help - Limiting the number of bars

Thu, 05 Jul 2012 06:27:22 GMT

Hi..

I have been working on Qlikview's Tutorial file for a while and I have encountered a problem on the manual.

On page 68 there is a specified explanation on how to limit the numbers of bars displayed.

The problem is that the in the bar chart properties tab there is no "Dimension Limitations" panel and no "Max Visible Number" checkbox.

I have been searching other alternatives but couldn't find one.

attached is a comparrison between the tutorial version and the current Qlikview layout i see. the QV version i work with is 11.00.11282.0 SR1.

so how do Limit the number of bars shown on a bar chart??

Thanks in advance,

evya

Re: Tutorial Help - Limiting the number of bars

Anonymous — Thu, 05 Jul 2012 06:32:54 GMT

Hi Evya,

You should have a Dimension Limits tab in the bar chart properties box (you might need to scroll to the left using the small arrows on the right at the tab row?).

Then you can check: "Restrict which values are displayed using the first expression"

And then "Show Only" + "First" + X Values.

Re: Tutorial Help - Limiting the number of bars

Thu, 05 Jul 2012 07:03:44 GMT

Thanks a lot Johannes!

I will take advantage of your help and ask another question regarding the bars-

when I use the dimensions limitations as you stated, I get a random (so I guess..) group of bars in the amount I asked.

how do I scroll to the other bars? in other words - how do i activate a scroll bar?

I will gladly accept other options as well..

And another thing - there is an "Others" bar shown with the rest of the entities. how do I get rid of it? is this bar essential?

Re: Tutorial Help - Limiting the number of bars

kji — Thu, 05 Jul 2012 07:13:43 GMT

If you want a limted number of bars shown at a time, but the ability to scroll over all values, you should use the "Enable X-axis Scrollbar" on the Presentation tab of properties instead of Dimension Limits. The Others bar you can turn off on the lower half of the Dimension Limits tab by unchecking "Show Others".