Percentage of FY Elapsed

[mesmail]

Hi All,

I'm pretty new at Qlik Sense and usually going through the forums I can find enough information to solve any issues I come across. But now I'm stuck. I have a requirement to show the percentage of the FY that has elapsed. I have the information in the Calendar table but I'm not sure how to write the expression using #1 KPI. 

This would be the select if I was doing this in the database:

select fiscalperelapsed

from calendar

where calendardate = sysdate

Thanks for the help!!

ME

[mesmail · Accepted solution]

This worked: 

num(Sum({1<CalendarDate = {'$(=Date(Today(), 'YYYY-MM-DD'))'}>}FiscalPerElapsed), '##.##%')