Filtering data

[stephenhasson]

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

[pradosh_thakur]

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]

Ok, thanks for your reply.