Skip to Content
author's profile photo Former Member
Former Member

Filter By Member is not displaying more than 100 values for a week

Hello ,

We have a scenario where Year is in filter for query. Each year has 52 weeks which is based on 0fiscper.

If user selects one year Example 2015 or 2014 it displays all 052 weeks in filter for week.

But if user enters two years 2015 and 2014 we have in total 104 weeks and filter displays only first 100 values.Last 4 values are not available to filter.

Can anyone help me how to amend this setting to get all 104 values. We don't want to use Access Mode values in master data.

We are currently on 1.4.11.

office.PNG (15.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 14, 2015 at 07:43 AM

    Hi Indu,

    Can you check your settings. "Maximum number of members displayed in filter dialog"


    Settings.png (27.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Tammy Powlas

      Hi Tammy,

      I checked it too but it doesn't have an option to change Maximum Number of Members displayed. I tried changing ExcelGrid --> NrOfSingleCellsInContext to 1 but didn't help.Is it the right setting to use for it or I am missing anything. Can you please help.

      Thank you.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.