Calculate YTD and QTD in Qlik using count

Aspiring_Developer — Mon, 16 Sep 2024 05:35:52 GMT

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

Re: Calculate YTD and QTD in Qlik using count

diagonjope — Mon, 16 Sep 2024 16:08:53 GMT

Hi @Kushal_Chawda !

Try this:

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

Cheers,

++José

Re: Calculate YTD and QTD in Qlik using count

Kushal_Chawda — Mon, 16 Sep 2024 18:03:47 GMT

@Aspiring_Developer try below

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

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

topic Re: Calculate YTD and QTD in Qlik using count in App Development

Calculate YTD and QTD in Qlik using count

Re: Calculate YTD and QTD in Qlik using count

Re: Calculate YTD and QTD in Qlik using count