Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stephenhasson
Contributor

Filtering data

Hi,

Is it possible in Qlik Sense to pre-filter data.

For example, in an app which is concerned with inventory balances etc., I'd like to provide a sheet which is focused specifically on expiry-date controlled parts.  I know I can have a filter on a date field, but can I have the contents of the table limited to only those records where there is an expiry date set on the database record in question?

I have a number of areas where it makes sense to limit / pre-filter the data, based on the intent of the sheet in question.

Thanks

Stephen

2 Replies
pradosh_thakur
Valued Contributor III

Re: Filtering data

use two set of data if data size is not so large . one for one sheet second for another. filter using where clause in script and change the field name a little such that they don't auto concatenate .

regards

Pradosh

stephenhasson
Contributor

Re: Filtering data

Ok, thanks for your reply.