topic Re: Qlik Sense does not support filters on date fields from QVD files? in Connectivity & Data Prep

Qlik Sense does not support filters on date fields from QVD files?

d44973694 — Mon, 13 Dec 2021 21:14:08 GMT

I came across a weird call-out while going through Qlik help section 'Adding data from a new data source' which says that Qlik Sense does not support filters on date fields from QVD files.

Attached is a snapshot of the same. Is it true? I never faced this issue.

Re: Qlik Sense does not support filters on date fields from QVD files?

ToniKautto — Tue, 26 May 2020 00:07:20 GMT

The GUI filter option as referred in below link applies a WHERE clause in the generated load script. Whilst this is a fully valid syntax for QVD files, it breaks the optimization of the QVD file format and will not provide a performance optimized data load.
Filtering on ranges like dates would require a slightly more complex script, which the wizard does not currently support. The recommendation should be to compose QVD files in such way that date based filtering is not primarily required.

Manually you could filter a date field in QVD file by using Exists() function and filter against a previously loaded date field, for example by generating a field with all date within a desired range.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/LoadData/adding-data-new-data-source.htm

Re: Qlik Sense does not support filters on date fields from QVD files?

d44973694 — Wed, 27 May 2020 09:19:33 GMT

I tried applying a filter on date field using data manager and it worked. The script is generated and data is loaded accuartely. Not sure what restriction is being referred to.