Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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