Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

Different accounting years per client calender

Good day,

I am currently developing a Profit and Loss table for an accounting firm.

Now they want to see the tables per accounting year.

These accounting years are dependent on the client.

For example.

Client A

Year 1 : 01/01/2015 - 01/01/2016

Year 2: 01/01/2016- 01/04/2018

Year 3: 01/04/2018- 01/04/2019


Client B

Year 1: 01/05/2015 - 01/08/2017

Year 2: 01/08/2017 - 01/08/2019


Is there a way to make it so that Qlik Sense has a variable calendar so if there is a specific client selected it bases the calendars data on the examples given above?

How would one do this?

Maybe when they start the app, they have to select te client first and then the correct accounting years are selected?

And above that, are year comparissons possible in this way?


Thanks a bunch


1 Reply



Is there anyone who has a solution for this problem?

The only thing I have is an Excel file where all the accounting years and their dates are present per client.

I could really use some help in this project.

Thanks in advance