topic Re: Filter dates in QlikView

Filter dates

TomHolland — Sat, 16 Nov 2024 21:40:49 GMT

I have following dates in an Object Table:

1-12-2015
6-7-2015
8-12-2016
3-11-2017
5-11-2017
3-2-2009
18-6-2013
27-8-1965

I want to display only the dates as of 1-1-2017 using > in the search box but is does not work.

How can I solve this?

Re: Filter dates

Anil_Babu_Samineni — Fri, 28 Dec 2018 13:52:04 GMT

You mean, You want to create a field called FieldName and data should display until '1-1-2017' ??? What you mean by Search box?

Re: Filter dates

TomHolland — Fri, 28 Dec 2018 16:42:30 GMT

I do not want to creat a filed name, as I already have it "Date".

I want to be able to, instead of showing all dates, display only the dates as of ...

I understood this should be possible through filtering/searching in the Search Object (that I called the Search box) using ">".

But it does not work.

Re: Filter dates

sathishbabu_s_g — Fri, 28 Dec 2018 18:38:38 GMT

Hi Tom,

The List box supports wildcard search, may be you can control the values displaying in the list box using expression.

=if(ShipDate < '01-07-2017', MonthName(ShipDate))

Re: Filter dates

jonathandienst — Sat, 29 Dec 2018 08:28:38 GMT

Is the Date field text or a numeric Qlikview date value? Dates in DMY format will not filter correctly of they are string values. Convert them to dates during load with Date#(). The you should be able to filter the list box by typing ">=1-1-2017 "