Qlik Community

Ask a Question

New to Qlik Sense

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

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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