topic Re: Filter in Script in QlikView

Filter in Script

robert_gansel — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I am searching for a possibility to filter my database already in the script.

In the end it should give me the result as I would set a filter in the document and use the "Data limitation" which only leaves all data that match to this filter.

Is there a simple solution that would work at the end of the load script?

Thanks in advance.

Re: Filter in Script

Anonymous — Mon, 13 Feb 2017 13:06:00 GMT

Hi,

I am thinking that you can filter the first table, and then use "where exist" function to filter the rest of the data.

Where Exists() and resident load

Best regards,

Cosmina

Re: Filter in Script

ramasaisaksoft — Mon, 13 Feb 2017 14:34:41 GMT

Hi Robert,

while reloading the application you can do filter in 2 ways

-->Use debug mode for limiting the data(No of records from each table)

-->by using functions Where exist (),Match()...etc

so choose and elect by yourself as per your convenient.