topic Re: Help with Dimension Limits! in QlikView

Help with Dimension Limits!

Fri, 18 Apr 2014 18:24:46 GMT

Hi all,

I'm having an issue with dimension limits. I have a straight table with a list of users and their corresponding database access information. I want the user to have the option to dynamically limit the number of users shown in the table, but (I think) due to multiple dimensions, I'm unable to properly limit the data. I've attached a sample for reference.

Thanks,

Paul

Re: Help with Dimension Limits!

Fri, 18 Apr 2014 19:14:43 GMT

Paul,

Are you trying to put dimension limit of employee name? If yes, try this:

Re: Help with Dimension Limits!

Fri, 18 Apr 2014 19:19:26 GMT

Yes, I want to limit the employees displayed. I opened your solution and it looks like below on my computer. It still shows "Others" repeated multiple times, which is undesirable. If I have "Display # Users" set to 3, I only want to show the top 3 lines.

Re: Help with Dimension Limits!

maxgro — Fri, 18 Apr 2014 19:24:12 GMT

if you have multiple dimension you can

- uncheck show others

- or check and collapse inner dimension (see image)

explanation from online help

Show Others

Enabling this option will produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart.

Re: Re: Help with Dimension Limits!

Fri, 18 Apr 2014 19:24:37 GMT

unckeck 'Show others' under Dimension limits-Options.

Re: Re: Help with Dimension Limits!

Fri, 18 Apr 2014 19:27:00 GMT

Hey Paul,

Maybe like attached.

It will limit the rows based on the UserID. if you enter 5 it will show users with ID 1-5. If entered 8 1-8 and so on.

Thanks

Re: Help with Dimension Limits!

Fri, 18 Apr 2014 19:34:17 GMT

Great, this helps. So it's not possible the show "Others" if I do it like this? It would be nice for the user to understand that there are additional items that are part of the table, but they are not shown for now.