topic how to create table calculating previous, current and first values of month? in QlikView

how to create table calculating previous, current and first values of month?

Tue, 24 May 2011 08:48:09 GMT

The tast is to calculate turnover and quantity of good by different periods and it's dynamics form the firs period and from previous,

to see how values change.

so in a table we need to calculate by products/stores (2 demension in a group for a fast change in table) and periods (day/week/month/year in a group - change is also allowed).

1) turnover

2) quantity

3) increase of turnover/quantity from the first period in absolute value.

4) increase of turnover/quantity from the previous period in absolute value.

3) increase of turnover/quantity from the first period in %.

4) increase of turnover/quantity from the previous period in %.

see table as example,

how to create table calculating previous, current and first values of month?

Wed, 25 May 2011 12:31:41 GMT

and the sames with charts (lines) to see the increase

Re: how to create table calculating previous, current and first values of month?

kaushiknsolanki — Wed, 25 May 2011 13:09:04 GMT

Hi,

What ever i am able to do is in this example.

Hope this will help you

Regards,

Kaushik Solanki

Re: how to create table calculating previous, current and first values of month?

Thu, 09 Jun 2011 09:19:24 GMT

We managed to do this, before is not enough for calculation from the first period, but thanks for help (2 Kaushik.solanki).