topic Today between two dates !! in QlikView

Today between two dates !!

Anonymous — Sun, 12 Aug 2018 06:13:56 GMT

I have this kpi, how to compare today date between start date and end date ???

tamilarasu — Mon, 13 Aug 2018 17:23:22 GMT

Hi Bayan,

You can use above SQL query directly in Qlikview. Are you getting any error?

eduardo_dimperio — Mon, 13 Aug 2018 17:47:08 GMT

Maybe This

SYSDATE() between TO_DATE([start_date]) and TO_DATE([end_date])

Anonymous — Mon, 13 Aug 2018 19:11:33 GMT

I am using Qliksense not Qlikview

Anonymous — Mon, 13 Aug 2018 19:13:05 GMT

I will try it .

thanks.

eduardo_dimperio — Mon, 13 Aug 2018 19:26:59 GMT

Me too

tamilarasu — Tue, 14 Aug 2018 02:52:43 GMT

Is this not working in QlikSense? Did you get any error?

fabdulazeez — Tue, 14 Aug 2018 03:44:03 GMT

count({<effectivestartdate= {"<=$(=Today())"},effectiveenddate= {">$(=Today())"}>} distinct person_key)

eduardo_dimperio — Tue, 14 Aug 2018 19:26:03 GMT

No, what error did you receive?