Discussion board where members can get started with 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?
Go to Solution.
You could use a where filter like:
load * From Source where Year >= 2016;
or a first-statement like:
Yes, Only way to do this is to write it in the script.
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