topic Re: Count between 2 dates in QlikView

Count between 2 dates

Anonymous — Mon, 24 Apr 2017 20:17:04 GMT

Hello,

My logic below is not pulling the correct count when AdminDate=MedStartTime. For instance, when AdminDate is 3/17/2017 and MedStartTime is 3/17/2017 when Given='Y', it needs to be a count of 1 and not 0. Could someone please assist?

IF((AdminDate>=MedStartTime and AdminDate<=MedDiscountieTime) and Given='Y', 1,0)

Thank you.

Re: Count between 2 dates

swuehl — Mon, 24 Apr 2017 20:29:10 GMT

Full context, please.

It would be best if you post a small sample QVW.

Re: Count between 2 dates

Digvijay_Singh — Mon, 24 Apr 2017 20:52:14 GMT

Formula you shared above looks fine, checked in frontend and backend, worked fine, may be prob is somewhere else -

Re: Count between 2 dates

Anil_Babu_Samineni — Tue, 25 Apr 2017 01:52:55 GMT

Try with True false Condition in your way with each row or you may share application to check. Image is not the correct reply

Re: Count between 2 dates

prachisangewar — Tue, 25 Apr 2017 02:23:47 GMT

Hi,

Please check the Date Formats for all the Date columns, they should be in same format as you do not have any format on the formula.

Re: Count between 2 dates

sumitjadhav — Tue, 25 Apr 2017 06:27:37 GMT

Hi Vishal,

Try The Below Expression,

-->>

Output:

Hope this Works,

Thank's & Regards,

Sumit Jadhav

Re: Count between 2 dates

Anonymous — Tue, 25 Apr 2017 12:53:30 GMT

The issue was with the date format in my sql script. I used the same date format for all the 3 dates and the same formula worked fine. Thank you.

Re: Count between 2 dates

swuehl — Tue, 25 Apr 2017 13:22:05 GMT

The date (textual) format should not be a problem, if the values show an underlying numeric value as well, as all date field values should:

Get the Dates Right

A problem could arise if you are in fact coping with timestamps and just format these as dates (so there is still a numeric value, that for example shows a time around noon, but the text representation dismisses this part).

For example, it's not enough to use

Date(TIMESTAMP) as Date

you need to use

Date(Floor(TIMESTAMP)) as Date

Dayname(TIMESTAMP) as Date

to get rid of the time part.