Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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

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

View solution in original post

Not applicable

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

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