topic Re: listbox filter in QlikView

listbox filter

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

Is there a way to filter dates via the from end search for listbox.

I try the following syntax:

for between 01/01/2018 and 01/01/2019:

>01/01/2018<01/01/2019

but no good,

any idea

thanks

Re: listbox filter

sunny_talwar — Fri, 13 Apr 2018 08:51:59 GMT

Go through this thread for searching...

Compound Search - demystified

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 08:53:17 GMT

I looked at it earlier, but no mention of dates

Re: listbox filter

YoussefBelloum — Fri, 13 Apr 2018 08:53:25 GMT

Hi,

to do this, you should use a Date field with this format DD/MM/YYYY and show it like the format shown above.

with this:

=Date(Date_field,'DD MMM YYYY')

Like this, you can search using a Start and an end dates like described above.

PS: your Date_field should have this format DD/MM/YYYY, or DDMMYYYY or whatever format in full numeric value

Re: listbox filter

sunny_talwar — Fri, 13 Apr 2018 08:57:43 GMT

Try this

='>01/01/2018<01/01/2019'

='>01 Jan 2018<01 Jan 2019'

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 09:00:13 GMT

did not work

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 09:00:29 GMT

did not work

Re: listbox filter

sunny_talwar — Fri, 13 Apr 2018 09:01:47 GMT

Is your date field format DD MMM YYYY or are you just displaying it like this but the actual format is something else?

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 09:03:31 GMT

SET DateFormat='DD MMM YYYY';

Re: listbox filter

sunny_talwar — Fri, 13 Apr 2018 09:07:12 GMT

And how is the date created?

Date(Dates) as Dates?

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 09:08:15 GMT

no, you right, I will try that

Re: listbox filter

sunny_talwar — Fri, 13 Apr 2018 09:14:51 GMT

This seems to work

=Dates >= 43101 and Dates <= 43466

Re: listbox filter

Anonymous — Fri, 13 Apr 2018 09:15:08 GMT

Thant was the issue, many thanks!