topic Conditional Numbering AutoNumbering in QlikView

Conditional Numbering AutoNumbering

ngrunoz — Wed, 08 Mar 2017 07:07:10 GMT

Hi Guys. I have a situation where I have projects which runs during different time periods and I would want to plot the results of the project on a line chart for comparison. For me to be able to do this I would want the start for each period to be either Week 1 or Day 1 and then start Automatically numbering the time period from that to the end date of the period. How do I create expressions for this type of requirement in the load script?

Example data

DATE	Project	Units
03/08/2016	Project A	50
04/08/2016	Project A	30
05/08/2016	Project A	20
06/08/2016	Project A	40
07/08/2016	Project A	90
08/08/2016	Project A	20
09/08/2016	Project A	15
10/08/2016	Project A	22
11/08/2016	Project A	10
12/08/2016	Project A	100
13/08/2016	Project A	20
14/08/2016	Project A	65
15/08/2016	Project A	77
16/08/2016	Project A	88
17/08/2016	Project A	105
06/09/2016	Project B	120
07/09/2016	Project B	130
08/09/2016	Project B	90
09/09/2016	Project B	70
10/09/2016	Project B	69
11/09/2016	Project B	87
12/09/2016	Project B	39
13/09/2016	Project B	45
14/09/2016	Project B	56
15/09/2016	Project B	60
16/09/2016	Project B	70

Re: Conditional Numbering AutoNumbering

hector_munoz — Wed, 08 Mar 2017 07:29:35 GMT

Hi Rungano,

If the result you need is similar to below:

, look at the attached app.

Regards,
H

Re: Conditional Numbering AutoNumbering

ngrunoz — Wed, 08 Mar 2017 08:08:34 GMT

Hi Hector

The results that I want is when we start Project B then It start to re-count Day 1 and also week 1.

Re: Conditional Numbering AutoNumbering

hector_munoz — Wed, 08 Mar 2017 08:19:00 GMT

OK,

Try the attached app.

Regards,

Re: Conditional Numbering AutoNumbering

jonathandienst — Wed, 08 Mar 2017 08:27:31 GMT

Something like this (adapted to suit your load script):

LOAD

DATE,

Project,

Units,

AutoNumber(DATE, Project) as SequenceByProject

FROM ...