Limiting 1000 rows in straight table.

[pavansonu99]

Hi guys,

i have requirement like this

i have a dashboard which contains list box with countries and a stright table that should reflect details of countries

each countries have different number of rows . if we click on each country the details of the country should be displayed on straight table.

i have countries liike this

country      polulation

india          700000

japan         50000

kanya        90000

canada     40000

newyork    5000

if i click on any country i want to display first 1000 rows of each country

i have 14 dimensions and 11 expression in that 11 dimensions are hidden.

with dimension limits its not working

i have used this expression in all 11 expression definitions ---  if(rowno(total)<=1000,dimension) 

hear i am getting 1000 rows but for country india i has 700000 records  "Object out of Memory" error is displaying

can some help how to solve this , is there any expression that i can write in calculated dimension to get 1000 rows or  come out f this error.

[sasiparupudi1]

Use a calculation condition like may be below on your chart.

=if (sum(Aggr(count(Population),Country))<1000,1,0)

hth

Sas

[pavansonu99]

Sorry Sasidhar this is not working.

[adamdavi3s]

This will just cause the load to fail if there are more than 1000 rows and not return any rows at all