Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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.
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