topic Re: I have Year and Month how to Get No of Days in Month in QlikView

I have Year and Month how to Get No of Days in Month

Anonymous — Mon, 29 Aug 2016 10:24:21 GMT

Hi Dears,

I have a table of Years and Months like This

Month, Year

Dec, 2015

Nov, 2015

Jan, 2016

Oct, 2015

I want to know in an accurate way how many days are there in each month like this

Month, Year, Days

Dec, 2015 31

Nov, 2015 30

Jan, 2016 31

Oct, 2015 31

I Tried

LOAD *, (MonthEnd(Month)-MonthStart(Month)) as Days

but this resulted in 31 Days in all months although it is known that Nov is only 30 Days.

Thanks in advance

stalwar1‌

sokkorn_cheav‌

swr‌

gwassenaar‌

jontydkpi‌

Re: I have Year and Month how to Get No of Days in Month

sunny_talwar — Mon, 29 Aug 2016 10:28:30 GMT

May be like this:

LOAD Month,

Year,

Day(MonthEnd(MakeDate(Year, Month(Date#(Month, 'MMM')), 1))) as Days

FROM...

Update: Sample attached

Re: I have Year and Month how to Get No of Days in Month

Anonymous — Mon, 29 Aug 2016 10:29:17 GMT

One way, you can use Inline, like this?

load * inline

[Month, Days

Jan, 31

Feb, 28/29

Mar, 31

so on..

];

then you can link it or map it.

Re: I have Year and Month how to Get No of Days in Month

MarcoWedel — Mon, 29 Aug 2016 21:34:13 GMT

Hi,

another solution might be:

Day(AddMonths(Date#(Month&Year,'MMMYYYY'),1)-1) as Days

hope this helps

regards

Marco

Re: I have Year and Month how to Get No of Days in Month

Chanty4u — Thu, 01 Sep 2016 12:26:20 GMT

Nice Sunny T

Re: I have Year and Month how to Get No of Days in Month

sunny_talwar — Thu, 01 Sep 2016 12:26:58 GMT

Thanks brother