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: 
Not applicable

Limited Data from a Data Table before bringing into Qlik Sense

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?

1 Solution

Accepted Solutions
marcus_sommer

You could use a where filter like:

load * From Source where Year >= 2016;

or a first-statement like:

first 10000

load ....

- Marcus

View solution in original post

3 Replies
marcus_sommer

You could use a where filter like:

load * From Source where Year >= 2016;

or a first-statement like:

first 10000

load ....

- Marcus

lakshmikandh
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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.