Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator III

How to limit rows of a table

Hello,

I am trying to limit rows of a table box or a straight table . Our data volume is huge .

Even though applying filters on 5 fields in straight table it is giving out of memory object message.

In the straight table I have 10 columns and only one expression which has 

=if( rowno(total)<=30,1) - to limit only 30 rows.

I have tried a table box but it is not giving any value as well. In our fact table we have one column name flag and by default it has 1 value per row.

In table box I tried in calculate , on condition

count(flag)<=30, but it is showing calculation condition unfulfilled.

Could you please help how to limit rows.

Labels (1)
6 Replies
gf
Creator III
Creator III

Hi, 

  if you are using Straight table,go to "Presenation" tab there you can see radio button will help you to show no of

rows,it deponds on your "Expression" values. And also by using "Sort" tab you can select Top N "Max" or "Min"

values...

manoranjan_d
Specialist
Specialist

Go with Dimension limit in the straight table 

ashis
Creator III
Creator III
Author

Hi ,

Thank you for your reply.

 

Both the options that you mentioned, qlik first load all the data then try to limit it .

So basically it will not work when you have millions of records.

I have tried  both options though.

 

ashis
Creator III
Creator III
Author

This works with smaller data set but it doesn't work with millions of records. It just can't load all the data.

gf
Creator III
Creator III

Once I had a similar problem with a pivot table. 

I solved it by telling my pivot that it should start calculating after a specific selection is done.

qlikexample.PNG

My calculation for example looked like:

GetSelectedCount(FCO) <> 0 AND GetSelectedCount(JAHR) <> 0 AND GetSelectedCount(SPRACHE) <> 0

 

wandererroch
Contributor III
Contributor III

Another way would be to use count(<dimension field>) < #