Filter all dates equal and smaller current date

hbuchetmann — Tue, 27 Oct 2015 08:27:29 GMT

Greetings,

i have a question regarding following problem:

I have a simple table with a date field named Dat_LS and several other fields showing articels which have been delivered to customers and their amount.

Dat_LS shows the date, on which the article is delivered to the customer.

Dat_LS	LS_Number	Article	Description	Amount
28.Okt.15	900000	1	Test1	6,3
27.Okt.15	900008	3	Test3	2
26.Okt.15	900009	6	Test6	7
25.Okt.15	900010	6	Test6	4

What i want to do now but fail to acomplish by myself is to create a listbox or button, which selects all date equal or smaller to the current date.

Lets say its today, 27.10.2015. When i click the button, a filter should be applied to only show all the articles delivered until the 27.okt.15. (something like [select all dates <=today()])

Can anyone offer an idea how to realize this?

Re: Filter all dates equal and smaller current date

hbuchetmann — Wed, 28 Oct 2015 08:54:50 GMT

I have found the solution in another post:

The correct Syntax for the Trigger in the listbox is

='=Dat_LS<=today()'

If i want to only Show the dates until yesterday:

='=Dat_LS<=(today()-1)'

The Post with the original answer can be found here:

Re: Show Dates Less Than or Equal to Selection

Thanks to Brandon Breitling for the easy solution, and sorry for opening a new post to an already solved Problem.

topic Re: Filter all dates equal and smaller current date in QlikView

Filter all dates equal and smaller current date

Re: Filter all dates equal and smaller current date