topic Re: Button to select from a specific date in QlikView

Button to select from a specific date

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

Hi,

A simple this one i'm sure. I have a few buttons that allow me to select data from the last 7, 14 and 30 days.

They all use an adaption of this: ='>=$(=(Date(Today()-7)))<=$(=(Date(Today()-0)))'

What i need now is a button that selects all data from a specific date (01/01/2019) but i can't quite work out the syntax.

Can anyone help?

Thanks.

Re: Button to select from a specific date

Anil_Babu_Samineni — Tue, 19 Mar 2019 11:20:26 GMT

Create button -> Actions tab -> Add -> Select in field -> DateField as Field and string as follows. Make sure about your Date format.

='>=' & Date(Max(DateField-7)) & '<=' & Date(Max(DateField))

Re: Button to select from a specific date

peterderrington — Thu, 21 Mar 2019 13:08:51 GMT

Sorry for the late reply, work commitments!

So i tried your formula and obviously i haven't done it correctly, i need to understand where i need to put the specific date in that i want it to show results from, the formula that you have given me just shows all the data.

Re: Button to select from a specific date

peterderrington — Wed, 27 Mar 2019 14:44:33 GMT

Can anybody else help here?

Just need to be able to filter my results from a specific date with a simple button.