topic Re: Use Between inside set analysis in QlikView

Use Between inside set analysis

anuradhaa — Mon, 02 Nov 2015 06:22:41 GMT

Hi,

I have date field called "Start Date" and it is in a format "10/31/2015 12:01:00 AM".

I want to get count(Start Date) for recent two dates.

If today is 2015/11/02 then i have to display 2015/11/02 and 2015/11/01.

I used =count({$<Start Date={"=Start Date>=Now(1)-2"}>}Country) as one expression and

=count({$<Start Date={"=Start Date>=Now(1)-1"}>}Country)

Re: Use Between inside set analysis

sasikanth — Mon, 02 Nov 2015 06:31:54 GMT

Try some thing like

count({$<Start Date={"=Start Date>=Date(Now(1)-2)"}>}Country)

Re: Use Between inside set analysis

tamilarasu — Mon, 02 Nov 2015 06:46:07 GMT

Hi AnuRadha,

Check the below one,

Count({$<Start Date={">=$(=Date(Now(1)-2,'DD/MM/YYYY hh:mm:ss tt'))"}>}Country)

Re: Use Between inside set analysis

Anonymous — Mon, 02 Nov 2015 06:46:37 GMT

First make sure format of both the dates is same.

You can take two variables like:

VStartDate=date(FieldName,'DD/MMM/YYYY')

VTodayDate=Date(Now(), 'DD/MMM/YYYY')

then your expression like:

=count({<StartDate={'>=$(=VStartDate)<=$(=VTodayDate)'}>} Country)

Hope This will Help!!!

Re: Use Between inside set analysis

anuradhaa — Mon, 02 Nov 2015 07:06:24 GMT

Any of those solutions doesn't work.

Re: Use Between inside set analysis

jagan — Mon, 02 Nov 2015 07:09:31 GMT

Hi,

Try like this

=count({$<[Start Date]={">=$(=Date(Today()-1))<=$(=Today()) "}>}Country)

Note: Date format Start Date and Today should be in the same format.

Hope this helps you.

Regards,

Jagan.

Re: Use Between inside set analysis

Anonymous — Mon, 02 Nov 2015 07:10:04 GMT

Share the sample data..

Re: Use Between inside set analysis

anuradhaa — Mon, 02 Nov 2015 07:46:09 GMT

Hi Please use below excel, here mydate shows the date field i have

Re: Use Between inside set analysis

sasikanth — Mon, 02 Nov 2015 07:59:41 GMT

hi,

=count({<[MY Date]={">=$(=Date(now()-2) ,'MM/DD/YYYY hh:mm:ss tt')"}>}Country)

Working for Date level, check once

Re: Use Between inside set analysis

settu_periasamy — Mon, 02 Nov 2015 08:02:20 GMT

Hi,

try this..

=Count({<[MY Date]={">=$(=Timestamp(Max(Floor([MY Date])-1)))"}>}Country)

Re: Use Between inside set analysis

anuradhaa — Mon, 02 Nov 2015 08:11:22 GMT

please check my attache excel sheet.

I have used your expression, but when i take Date(now()-2) and Date(now()-1)

It gives same vales