topic Dimension Limits in QlikView

Dimension Limits

Thu, 12 Mar 2015 03:04:38 GMT

Dear All

I try to limit to display only 5 lowest value in my dimension but it shows only 4 lowest value.

How to correct this kind of problem

Regards

Sofyan Bahri

Re: Dimension Limits

anbu1984 — Thu, 12 Mar 2015 03:30:09 GMT

Uncheck "Show Others" option in Dimension limits tab

Re: Dimension Limits

Thu, 12 Mar 2015 03:34:12 GMT

Hi Sofyan,

Can you check if the "show others" check box in Options section of the dimension limit tab is checked or not.

If it is checked, please uncheck and try again.

Regards,

NGS

Re: Dimension Limits

Thu, 12 Mar 2015 03:40:28 GMT

You have to uncheck the 'Show Others' option in dimension limits tab.

Because usually If you limit with 5 value by check-in with 'Show others option,It will also count the show others row too- You will get 4 lowest value row + other value row.

Regards

Lathaa

Re: Dimension Limits

aveeeeeee7en — Thu, 12 Mar 2015 04:00:31 GMT

Rather than calculating Lowest 5 Values from Dimension Limits create a new Expression as:

=aggr(if(Rank(-Sum(Value))<=5,Value),State)

Kindly change the field names

Hope that helps you.

Regards

Av7eN

Re: Dimension Limits

mukesh24 — Thu, 12 Mar 2015 04:11:49 GMT

Hi,

In dimension limit tab uncheck "Show Others"option.