topic Re: count the value between date range in QlikView

count the value between date range

settu_periasamy — Tue, 17 Feb 2015 06:32:38 GMT

Hi,

i have the field CallID and Call_date (this is date with time format). I need to show the count based start and end date.

see the below screen shot.

Just i want to show, call_date(date only) and count of CallID based on the date. sample is attached.

senpradip007 — Tue, 17 Feb 2015 06:41:34 GMT

PFA. hope it will help.

settu_periasamy — Tue, 17 Feb 2015 06:53:13 GMT

thanks pradip. is it possible to do this, without adding date field in the script?

jagan — Tue, 17 Feb 2015 07:04:34 GMT

Hi,

Try this expression

Count({<Call_date = {">=$(TimeStamp(start))<=$(TimeStamp(end))"}>} CallID)

Regards,

Jagan.

settu_periasamy — Tue, 17 Feb 2015 07:26:30 GMT

Thank you Jagan. Just i have add the "=" infront of Timestamp. Now it is working.

final expression is Count({<Call_date = {">=$(=TimeStamp(start))<=$(=TimeStamp(end))"}>} CallID)