Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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
Anonymous
Not applicable
Author

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)

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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
Master II
Master II

May be like this?

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

vikramv
Creator III
Creator III

try like this with double quotes

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

Anonymous
Not applicable
Author

This worked with the following, slight adjustment.

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

Thanks

Phil