Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw


talk is cheap, supply exceeds demand
Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Not applicable

Thanks Gysbert! You are life saver.

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

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