Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
prat1214
Contributor
Contributor

KPI

want to include a KPI which should give count of the basis of start date and current date in qlik sense

 

Consider count of Field
In between Date_field & SYDATE (System date/Today's date) 
Labels (1)
2 Replies
pallavi_96
Partner - Creator
Partner - Creator

Hi @prat1214 

Try to use below expression 

Count({<startdate={">=$(=max(Date(startdate())))<=$(=Date(Today()))"}>} YourField)

 

Padma123
Creator
Creator

Hi,

try the below function

fabs(Interval(date - Today(),'d'))