Discussion board where members can get started with Qlik Sense.
I have a excel file where I have months as headers and salaries of employees for 2017 as sample data shown in the screenshot.
I have to get output as last six months salary of employees for 2017 as shown below
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.
qvw and sample data in the attachment
result in image