Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor
Partner - Contributor

Filter and aggrecation by fiscal year

Hi Community,


I am working in a app with juridical data. In my data I have a presentation date(the day when the case is created) and a termination date(when the case is closed). I need to created a filter by fiscal year, how can I created that filter?

I also have to create 3 KPIs, one for presented cases(the cases that was created in the selected fiscal year), other for cases closed(the cases that was closed in the selected fiscal year but also need to include the cases that was open in past fiscal years but was closed in the selected fiscal year) and one for the pending cases(the cases that are still open in the selected year and including cases from past years that are still open). Have can I can create those calculations?


I am new to Qlik products and BI development, thanks for the help!



0 Replies