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

How to add last 6 months which are in columns in excel file

Hi ,

I have a excel file where I have months as headers and salaries of employees for 2017 as  sample data shown in the screenshot.source_table.png

I have to get output as last six months salary of employees for 2017 as shown below

output.png

Each month we new month salaries updated so we have to get sum of last six months salary and this continues every month.

Can anyone help me on this.

Thanks in advance.

1 Reply
maxgro
MVP
MVP

qvw and sample data in the attachment

result in image

1.png