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: 
uko223
Contributor III
Contributor III

How to limit data in QlikSense Straight Table

Hi, I have a sheet with a straight table that does not have any predefined criteria selected when first getting into it and as such, the straight table takes a while to load as it attempts to load everything. I would like to limit the data that is initially loaded past a certain row. Any advice?

Thanks!

1 Solution

Accepted Solutions
Anonymous
Not applicable

Ok well it depend how you want to filter the table.

Do you want to filter it by seeing the latest information first? or do you want to see it by the highest shipping amount first?

If it is the shipping amount, then just go to one of the dimensions in your straight table, choose 'limitations' and you can specify by the top, however many records you want to appear.

if it is the date, then add the date as a measure like e.g. Max(shippingDate)

Then do the same with the dimension, go to limitations. and make sure it is basing it off the measure Max(shippingDate). It will say underneath the limitation section if it is or not.

Check this out too for a better understanding: https://community.qlik.com/docs/DOC-7006

Hope this helps

View solution in original post

8 Replies
rittermd
Master
Master

I think your only option is to limit the data in the load script with a where clause.  But if you do that then all of the data is not going to be available to the app if you need that.

Anonymous
Not applicable

Hi Dan,

Do you have a measure within your straight table?

Thanks

simondachstr
Luminary Alumni
Luminary Alumni

The Vizlib Table (https://www.vizlib.com/table) has such a setting in place.

uko223
Contributor III
Contributor III
Author

Yes, its order detail so each line of data sums the shipping amount.

Anonymous
Not applicable

Ok well it depend how you want to filter the table.

Do you want to filter it by seeing the latest information first? or do you want to see it by the highest shipping amount first?

If it is the shipping amount, then just go to one of the dimensions in your straight table, choose 'limitations' and you can specify by the top, however many records you want to appear.

if it is the date, then add the date as a measure like e.g. Max(shippingDate)

Then do the same with the dimension, go to limitations. and make sure it is basing it off the measure Max(shippingDate). It will say underneath the limitation section if it is or not.

Check this out too for a better understanding: https://community.qlik.com/docs/DOC-7006

Hope this helps

uko223
Contributor III
Contributor III
Author

Thank you!

uko223
Contributor III
Contributor III
Author

This is awesome! Thanks!

Anonymous
Not applicable

No problem!