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: 
Not applicable

Rolling months on 2 month fields in straight table

Hello Community,

I have the scenario of rolling months. Please see the attached file and the expected results.

Example:

For cal_month =  Mar, I need sum of value against processed_month = Mar, from each cal_month rolling up i.e Jan, Feb and Mar

Thanks,

Singh

1 Solution

Accepted Solutions
Gysbert_Wassenaar

This document may help to understand the issue with using set analysis: set_analysis_intra-record.qvw


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Gysbert,

Thanks man, that works as expected. Is it possible to have same in set analysis. Since i pulled out this logic out of my whole setup.
Since I believe, we cannot compare fields in set analysis. Is there any work around ?

Thanks,

Angad

Gysbert_Wassenaar

This document may help to understand the issue with using set analysis: set_analysis_intra-record.qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert! You are life saver.

Gysbert_Wassenaar

If these kind of problems can cost you your life, then perhaps you should find another employer


talk is cheap, supply exceeds demand
Not applicable
Author

It was not said in a literal way. Though I am looking for a change.