topic Re: KPI in App Development

KPI

prat1214 — Fri, 15 Nov 2024 20:50:37 GMT

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)

pallavi_96 — Mon, 04 Nov 2024 08:41:45 GMT

Try to use below expression

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

Padma123 — Mon, 04 Nov 2024 09:21:16 GMT

Hi,

try the below function

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