Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a a Profit chart .. which incldes the company assets and liabilities ,net revenure etc.. most of values changes every month based on certain value called --"Calculation Rate" which we manually change every end of month..
now my question ,,i need a good way to keep back of this chart.. every month so i can always compare the data between previous and current month
any suggestions here
Hi,
This is difficult to answer definitively without getting a look at your application, but I'll tell you how I would tackle this.
I'd implement an incremental load here, and make sure that all your relevant data is saved with the date of the snapshot. That way, you can change your calculation by adding a set analysis parameter for whatever snapshot date you want to return.
Marcus
Hi
I am providing only examples
Provided : MonthYear is your Month wise variable
and
calculation on "net revenure"
For last month sales:
Sum({$<[MonthYear]={"$(=Date(AddMonths(Max(MonthYear), -1), 'MMM-YYYY'))"}>}[net revenure])
For last current month sales
Sum({$<[MonthYear]={"$(=Date((Max(MonthYear), 'MMM-YYYY'))"}>}[net revenure])
***
Please provide more information/sample data for further help
i need to maintain a back up... before the end of every months
Hi,
You should look for the incremental Load.
When I say incremental it means that you keep on storing the old data in QVD and then use it.
Lets say you have data for Jan 2016 then create a QVD which will have Jan 2016 Data.
Now in Feb 2016, append the Feb Data in Jan QVD. So now you have data for 2 months.
Like wise you can keep on storing the data.
Regards,
Kaushik Solanki
can u share me the store command to store specific to month and year as file name?
Your script will be like this.
Data:
Load * from ExistingQVD.qvd();
Concatenate
Load *,Makedate(2016,02,01) as Month
From
Feb2016.xls;
Store Data into ExistingQVD;
Regards,
Kaushik Solanki
Are you manually applying the calculation logic in the script or UI?