Calculate YTD and QTD in Qlik using count

[Aspiring_Developer]

Hello All, 

I have below data comprising details about incidents:-

This month year is created in the backend script from the field -Incident Occurred Date

If I add date column in the above, my data would look like this :-

I want to achieve below :-

1) Calculate YTD by taking the count(ID) . In my data set the max of date is 2025 as I have the forecast dates but in this I just have the data values till max month and my data is starting from April 2023 and I want to to show it till max (month ) as of today . I tried below expression but it did not worked :-

Sum({<[Incident Occurred Date]={"<=$(=Date(Today(), 'MM/DD/YYYY'))"}>} [Count(ID)]) 

This gives -Error in expression 

2) I also want to show MTD, QoQ for the above in the KPI and and in the form of line chart 

My expression should take the count of ID and not sum because when I take the sum, it gives me a lot of values:-

How can I achieve this?

@Kushal_Chawda  

[diagonjope]

Hi @Kushal_Chawda !

Try this:

Sum({< [Incident Occurred Date]={"<=$(=date(Today(1), 'MM/DD/YYYY'))"} >}  [Count(ID)]) 

Cheers,

++José

[Kushal_Chawda · Accepted solution]

@Aspiring_Developer  try below

Count({<[Incident Occurred Date]={"<=$(=Date(Today()))"}>} ID) 

or

Count(distinct {<[Incident Occurred Date]={"<=$(=Date(Today()))"}>} ID)