Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vijayvalli
New Contributor II

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
MVP
MVP

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

qvw and sample data in the attachment

result in image

1.png

Community Browser