topic chart in QlikView

chart

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: chart

marcus_malinow — Mon, 12 Sep 2016 14:08:11 GMT

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

Re: chart

Anonymous — Mon, 12 Sep 2016 14:47:47 GMT

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

Re: chart

raadwiptec — Tue, 13 Sep 2016 08:28:36 GMT

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

Re: chart

kaushiknsolanki — Tue, 13 Sep 2016 08:34:41 GMT

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

Re: chart

raadwiptec — Tue, 13 Sep 2016 09:14:27 GMT

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

Re: chart

kaushiknsolanki — Tue, 13 Sep 2016 09:27:11 GMT

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

Re: chart

chetansehgal — Tue, 13 Sep 2016 10:14:02 GMT

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