topic Re: Numbering based on date in QlikView

Numbering based on date

kishorj1982 — Wed, 18 Oct 2017 06:47:25 GMT

Hi All,

PFA.

I need to use numbering from 1 to 12 from Jun 2017 to May 2018 .

Can you pelase suggest how to do it dynamically.

thanks

Re: Numbering based on date

Anil_Babu_Samineni — Wed, 18 Oct 2017 07:03:15 GMT

In your model ,I have not seen any related Jun 2017.... And you have numeric months too like MonthNo. If you want you can use that

If you want to load missing dates i believe you may need master calendar for that.

Re: Numbering based on date

hic — Wed, 18 Oct 2017 10:57:41 GMT

The following will give you a month number where June 2017 is equal to 1.

=12*Year(DtDate) + Month(DtDate) - 24209

HIC

Re: Numbering based on date

effinty2112 — Wed, 18 Oct 2017 12:19:49 GMT

Hi Kishor,

Try:

Mod(MonthNo-6,12)+1

Cheers

Andrew

Re: Numbering based on date

Wed, 18 Oct 2017 13:12:14 GMT

Hi Kishor,

I have a similar situation here, our customer usually have a different year start and end than the standard(JAN to DEC), we get that information from their Data Base, identifying which period refers to which year, if you only have one period per year, you can use that.

Often we use a interval match to make a relation between this new time period and the revenue and such.

Hope this helps.

Gabriel