Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eric_cabeza
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!

 

Eric

0 Replies