Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
54321Adam
Contributor
Contributor

Set analysis with date filter

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.

Labels (1)
2 Replies
sidhiq91
Specialist II
Specialist II

@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
Contributor
Contributor
Author

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