Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cocobello3
Contributor II
Contributor II

Qlik sense financial cumulated balance

Hi all,

I m using Qlik Sense with data connected to a reporting tool. All financial data are cumulated data (YTD). How can I calculated monthly data ?

Period selected - Previous period

Thanks !

Labels (1)
1 Solution

Accepted Solutions
Wlad_Masi
Employee
Employee

If you do not have any parameter/field/data,  that will allow you to measure with single dates you will have to create a rule to split the data.
If you have any field with date data, you can use the function Date(Field) and get the month of it.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.

View solution in original post

3 Replies
Wlad_Masi
Employee
Employee

If you do not have any parameter/field/data,  that will allow you to measure with single dates you will have to create a rule to split the data.
If you have any field with date data, you can use the function Date(Field) and get the month of it.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
cocobello3
Contributor II
Contributor II
Author

Thanks for your help !

Wlad_Masi
Employee
Employee

@cocobello3  You are welcome.
Please mark this post as solved if your questions was answered please.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.