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!
Eric
