topic Re: Numbering Year Months progressively in QlikView

Numbering Year Months progressively

Tue, 01 Aug 2017 06:40:46 GMT

Hi to all,

I've to assign a progressive number to Year Months in the script using Qlik Sense.

For example:

2017/07 1

2017/08 2

2017/09 3

2017/10 4

2017/11 5

2017/12 6

2018/01 7

2018/02 8

2018/03 9

And so on... Which is the best way to do this?

Thank you for anyone helps me.

Alessandro

Re: Numbering Year Months progressively

tresB — Tue, 01 Aug 2017 07:28:14 GMT

Try like:

Load

YearMonth,

AutoNumber(YearMonth) as Sequence

Re: Numbering Year Months progressively

zhadrakas — Tue, 01 Aug 2017 07:30:02 GMT

What about

autonumber(YearMonth) as Number

maybe you Need to sort your table before.

You could do this with presceding load

Load *,

autonumber(YearMonth) as Number

;

Load *

From ABC

order by MonthYear ASC

;

Re: Numbering Year Months progressively

rahulpawarb — Tue, 01 Aug 2017 07:41:35 GMT

I agree with Tim! If YearMonth values are not in order then use of Only AutoNumber will not work; we need to couple it with Order By clause to get desired results.

Regards!

Rahul Pawar