Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

sales division in monthly sales regarding the run-time

Hi,

I am a beginner and need your help.

I have a sales Value like 5000 (Project price) in Jan. 2014 but I need to build a table with monthly sales regarding the run-time of the project as 5 Month. This means: the customer pays 1000 every month. The same must be defined for a lot of projects.

Example:

My Table is:

Project     begin               price     project run-time (in Month)

A             01.02.2014       5000     5

B             01.03.2014       2000     2

C             01.04.2014       3000     3

My result must be look like:

-------------------------------------------------------------------------------------------------

               Jan     Feb      Mrz      Apr       Mai       Jun     Jul     Aug

Result:     0        1000    2000     3000     2000     2000    

-------------------------------------------------------------------------------------------------

Result explanation:

               Jan     Feb      Mrz      Apr       Mai       Jun     Jul     Aug

Project

A               0        1000    1000     1000     1000     1000    

B               0        0         1000     1000      0           0    

C               0        0         0          1000     1000     1000    

I hope, somebody can help me.

Regards

HA

1 Solution

Accepted Solutions

Re: sales division in monthly sales regarding the run-time

See attached example.


talk is cheap, supply exceeds demand
2 Replies

Re: sales division in monthly sales regarding the run-time

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: sales division in monthly sales regarding the run-time

Hi gwassenaar,

thank you very mutch!!!!!!!!!!!!!!!

Community Browser