Limited Data from a Data Table before bringing into Qlik Sense

[#1]

I have a data table that I am connected to -

I wanted to limit the amount of data that I bring into the App.

Is the only way to do this is to write it in the script? Is there a filter I can filter on to select what I want and then load data?

[marcus_sommer · Accepted solution]

You could use a where filter like:

load * From Source where Year >= 2016;

or a first-statement like:

first 10000

load ....

- Marcus

[lakshmikandh]

Yes, Only way to do this is to write it in the script.

[Anonymous]

Hi Lauren,

You can use 2 method actually:

1. You can use "Where" function in the script, usually using the w="where" function is the best way,

because you can specific reduce the data by specific field.

2. You can use "Debug" button,next to "Load Data" button.

you can limit by record.

Hope this help

Best Regards,

Ryan.