chart

[raadwiptec]

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

[marcus_malinow]

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

[Anonymous]

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

[raadwiptec]

i need to maintain a back up... before the end of every months

[kaushiknsolanki]

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

[raadwiptec]

can u share me the store command to store specific to month and year as file name?

[kaushiknsolanki]

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

[chetansehgal]

Are you manually applying the calculation logic in the script or  UI?