Set analysis with date filter

[54321Adam]

I'm fairly new to Qlik Sense, but am picking it up pretty quickly (I think) - I am completely stumped by this issue though...

So, I have a set of data with applications in it for current period and previous ones.  These are easily identified as the data includes a year of entry and date the application was completed.

Splitting them out into their year of entry is fine.  Where I'm falling over is applying a date.  When a date is applied, it's applied to both sets.

The table will have 2021 application and 2022 ones.  If I select 29/07/2022 as the date it includes everything up to that date for both sets (2021 & 2022).  What I need is for it to apply 29/07/2022-365 to the 2021 data so that it compares like for like as at 29/07.

Any ideas?

I've uploaded some dummy data too if that helps.

[sidhiq91]

@54321Adam  Hello Adam, Could you please try something like the below expression.

Count({<CompletionDate={"$(=Date(Max(CompletionDate)-365,'MM/DD/YYYY'))"}>}CountApplications)

So every time you select a completionDate in the filter, it would get subtracted to 365 days and show last year's day data.

If this resolves your issue, please like and accept it as a solution.

[54321Adam]

Hi,

Thanks for sending this suggestion.  I don't think it has worked though as it only returns 0.

back to the drawing board for me!

Adam