topic Re: Savings calculation in QlikView

Savings calculation

kkkumar82 — Fri, 13 Oct 2017 13:45:54 GMT

Hi Qlikers,

I have some data in the below format

ProjectID	Org	StartMonth	EndMonth	Month1 Savings	Month2 savings	Month3 Savings	......	Month12 Savings

Based on the start month column and End month column will be having savings but the start month and end months for all the projects

may not be the same,

I want to have a table which can show me data like below

Project ID , ORG, OCT,NOV,DEC,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP

Note: For all projects it is not mandatory that they should have all months data, attaching a sample spread sheet.

Re: Savings calculation

sunny_talwar — Fri, 13 Oct 2017 14:03:46 GMT

This?

Re: Savings calculation

kkkumar82 — Fri, 13 Oct 2017 14:05:37 GMT

Give me a minute, I will check, meanwhile I think the data in the sample excel is also not correct, sorry for that

Re: Savings calculation

kkkumar82 — Fri, 13 Oct 2017 14:09:18 GMT

The table is close but, irrespective of the years can we get the data under the same months, I mean, oct 2016 or oct 2017 should come under oct, as we have in data model a calendar filters , we can filter out them by Fiscal Year and Fiscal Month

Re: Savings calculation

sunny_talwar — Fri, 13 Oct 2017 14:09:54 GMT

Change the MonthYear field with the Month field I have in the application

Re: Savings calculation

kkkumar82 — Fri, 13 Oct 2017 14:26:38 GMT

This can really help me thanks for the immediate jump, I need to play on this , as the original data is in fiscal and I also see some discrepancy in the data

Thanks much Sunny