Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
balmoshiegah
New Contributor

Today between two dates !!

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

IMG_6082.PNG

8 Replies
Highlighted

Re: Today between two dates !!

Hi Bayan,

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

Highlighted
eduardo_dimperio
Valued Contributor II

Re: Today between two dates !!

Maybe This

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

Highlighted
balmoshiegah
New Contributor

Re: Today between two dates !!

I am using Qliksense not Qlikview

Highlighted
balmoshiegah
New Contributor

Re: Today between two dates !!

I will try it .

thanks.

Highlighted
eduardo_dimperio
Valued Contributor II

Re: Today between two dates !!

Me too

Highlighted

Re: Today between two dates !!

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

Highlighted
Partner
Partner

Re: Today between two dates !!

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

Highlighted
eduardo_dimperio
Valued Contributor II

Re: Today between two dates !!

No, what error did you receive?