Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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?

Tags (1)
1 Solution

Accepted Solutions

Re: Limited Data from a Data Table before bringing into Qlik Sense

You could use a where filter like:

load * From Source where Year >= 2016;

or a first-statement like:

first 10000

load ....

- Marcus

3 Replies

Re: Limited Data from a Data Table before bringing into Qlik Sense

You could use a where filter like:

load * From Source where Year >= 2016;

or a first-statement like:

first 10000

load ....

- Marcus

lakshmikandh
Valued Contributor II

Re: Limited Data from a Data Table before bringing into Qlik Sense

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

ryan_thomas
New Contributor II

Re: Limited Data from a Data Table before bringing into Qlik Sense

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.