Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco
New Contributor II

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
mattquinnterex
Contributor II

Re: How to limit data in QlikSense Straight Table

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

8 Replies
rittermd
Honored Contributor

Re: How to limit data in QlikSense Straight Table

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.

mattquinnterex
Contributor II

Re: How to limit data in QlikSense Straight Table

Hi Dan,

Do you have a measure within your straight table?

Thanks

Luminary
Luminary

Re: How to limit data in QlikSense Straight Table

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

danielco
New Contributor II

Re: How to limit data in QlikSense Straight Table

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

mattquinnterex
Contributor II

Re: How to limit data in QlikSense Straight Table

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

danielco
New Contributor II

Re: How to limit data in QlikSense Straight Table

Thank you!

danielco
New Contributor II

Re: How to limit data in QlikSense Straight Table

This is awesome! Thanks!

mattquinnterex
Contributor II

Re: How to limit data in QlikSense Straight Table

No problem!

Community Browser