topic Re: Set Analysis Later Than Date But Less Than Today in QlikView

Set Analysis Later Than Date But Less Than Today

Anonymous — Fri, 15 Jul 2016 08:09:31 GMT

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

Anonymous — Fri, 15 Jul 2016 08:16:41 GMT

check this

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

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

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

Frank_Hartmann — Fri, 15 Jul 2016 08:17:01 GMT

May be like this?

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

vikramv — Fri, 15 Jul 2016 08:20:24 GMT

try like this with double quotes

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

Anonymous — Fri, 15 Jul 2016 08:21:36 GMT

This worked with the following, slight adjustment.

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

Thanks

Phil