QlikView 10 (Straight Table) Topn fails when variable is greater than 100

[#1]

Hi there,

I am running QlikView 10 SR1 and have created variable called vTopn. I have set the Max Visible option on the Presentation tab to = vTopn.

When vTopn has a value of less than 100 everything works 100% - ie. when vTopn is set to 20 only 20 rows display in the Straight table. When vTop has a value of more than 100 ie. 1000 the straight table still only shows a maximum of 100 rows. This function (ie. allowing to variable drive the row count above 100 rows) worked prefectly in QV8 as well as QV9.

I would be highly appreciative of any suggestions in this regard as thi is a function we rely heavily on and is now impacting the business.

thanks in advance,

kind regards,

sean

[deepakk]

hi

[deepakk]

hi,

You can try out the rank function. I am attaching a sample application. I hope its helps you out.

[#4]

Hi Deepak,

Many thanks for the reply - I have tested using the 'aggr' function. It seems to be working however, unfortunately the data model contains about 350,000,000 rows of data and the 'aggr' function is impacting performance quite negatively.

Sean