Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Today between two dates !!

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

IMG_6082.PNG

8 Replies
tamilarasu
Champion
Champion

Hi Bayan,

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

eduardo_dimperio
Specialist II
Specialist II

Maybe This

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

Anonymous
Not applicable
Author

I am using Qliksense not Qlikview

Anonymous
Not applicable
Author

I will try it .

thanks.

eduardo_dimperio
Specialist II
Specialist II

Me too

tamilarasu
Champion
Champion

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

fabdulazeez
Partner - Creator III
Partner - Creator III

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

eduardo_dimperio
Specialist II
Specialist II

No, what error did you receive?