Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

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,

Tags (2)
1 Solution

Accepted Solutions
Not applicable

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

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

3 Replies
Not applicable

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

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

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

Hi,

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

     Hope this will help you

Regards,

Kaushik Solanki

Not applicable

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

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

Community Browser