Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Button to select from a specific date

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.

3 Replies
Highlighted

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))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

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.

Highlighted
Creator II
Creator II

Can anybody else help here?

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