topic Max Number of Rows in QlikView

Max Number of Rows

Mon, 14 Mar 2011 18:22:49 GMT

I looked through a couple topics on this but never really found my answer.

I am trying to limit the number of rows that a table will display. I have set up a variable called "maxNumber" and clicked the check box under Presentation of my table and set the expression =maxNumber.

Is there any way to go beyond 100? I really want the max number of rows to be displayed to be 10,000. My slider that controls maxNumber goes from 1 to 10,000 but no matter where it is the table will still no matter what only show 100 rows.

Regards,

-TF, TS, THG

Max Number of Rows

pover — Tue, 15 Mar 2011 03:14:21 GMT

This isn't the prettiest solution if you have alot of expressions, but you could also try something like the following in all your expressions:

if(rowno(total)<=maxNumber,Expression)

Make sure to select the option to suppress zero values in the presentation tab.

Regards.

Max Number of Rows

Miguel_Angel_Baeyens — Tue, 15 Mar 2011 04:47:48 GMT

Hello,

If you are working in a QliKView Server environment, the server has this setting by default, that you may want to modify (number of max symbols in a chart). Go to the QlikView Enterprise Management Console, System, Performance, and change that setting.

In the document part, go to Settings menu, User Preferences, Objects tab, and modify this value "Max Symbols on Charts". Save and reopen the document.

Anyway, note that the higher the limit is, the longer the chart will take to render.

That should do.

Hope that helps.

Max Number of Rows

Fri, 05 Aug 2011 02:31:42 GMT

Hi, will post from Japan.

I have trouble issues this [Max Number].

I do contact a Japanese support center.

In V9, would be set.but no longer can't set from V10.

I wants to remove this restriction by QlikTech R&D.

Who wants to think it all over the world.

Re: Max Number of Rows

Wed, 15 Jun 2016 11:42:37 GMT

Hey,

Did you find any solution for this problem?, I know it has been passed a lot of years... but I am in the same situation a have no found any solutions here.

Many thnaks,

Regards