Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

philmywallet
Not applicable

Set Analysis Later Than Date But Less Than Today

Hi

I am trying to create a set analysis which returns data which is after 01/04/16, but less than todays date.

I can get it to work for data after 01/04/16, but how do I include the Less than today.

Here is my current script :

=Count({<

state={'Recruited'},

[Booked start date]={'>=42461'}

>} Applicationid)


Any thoughts on how I can stop future dates pulling through?



Thanks



Phil

1 Solution

Accepted Solutions
galax_allu
Not applicable

Re: Set Analysis Later Than Date But Less Than Today

Hi

check this

Assuming dates are in MM/DD/,YYYY format.

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=07/15/2016'}>} Applicationid)

OR

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'MM/DD/YYYY'))'}>} Applicationid)

4 Replies
galax_allu
Not applicable

Re: Set Analysis Later Than Date But Less Than Today

Hi

check this

Assuming dates are in MM/DD/,YYYY format.

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=07/15/2016'}>} Applicationid)

OR

=Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'MM/DD/YYYY'))'}>} Applicationid)

Frank_Hartmann
Not applicable

Re: Set Analysis Later Than Date But Less Than Today

May be like this?

count({<state={'Recruited'},[Booked start date]= {"$(='>=' & 42461 & '<=' & Floor(Today())"}>} Applicationid)

vikkyv
Not applicable

Re: Set Analysis Later Than Date But Less Than Today

try like this with double quotes

=Count({<state={'Recruited'},[Booked start date]={">='01/04/16'<=$(=date(Today(),'DD/MM/YYYY'))"}>} Applicationid)

philmywallet
Not applicable

Re: Set Analysis Later Than Date But Less Than Today

This worked with the following, slight adjustment.

Count({<state={'Recruited'},[Booked start date]={'>=01/04/16<=$(=Date(Today(),'DD/MM/YYYY'))'}>} Applicationid)

Thanks

Phil