Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this kpi, how to compare today date between start date and end date ???
Hi Bayan,
You can use above SQL query directly in Qlikview. Are you getting any error?
Maybe This
SYSDATE() between TO_DATE([start_date]) and TO_DATE([end_date])
I am using Qliksense not Qlikview
I will try it .
thanks.
Me too
Is this not working in QlikSense? Did you get any error?
count({<effectivestartdate= {"<=$(=Today())"},effectiveenddate= {">$(=Today())"}>} distinct person_key)
No, what error did you receive?