How to limit data in QlikSense Straight Table

[uko223]

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!

[rittermd]

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]

Hi Dan,

Do you have a measure within your straight table?

Thanks

[simondachstr]

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

[uko223]

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

[Anonymous · Accepted solution]

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]

Thank you!

[uko223]

This is awesome! Thanks!

[Anonymous]

No problem!