Solved

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Solved

Re: Get Number of Days per Month?

sunny_talwar — Thu, 28 Apr 2016 15:03:19 GMT

You can create it like this:

Floor(MonthEnd(FULL_DATE)) - Floor(MonthStart(FULL_DATE)) + 1 as DAYS

Re: Get Number of Days per Month?

Anonymous — Thu, 28 Apr 2016 15:08:50 GMT

...or maybe

Day(MonthEnd(FULL_DATE))

Re: Get Number of Days per Month?

sunny_talwar — Thu, 28 Apr 2016 15:11:08 GMT

Sample script:

Table:

LOAD Date(Date#(FULL_DATE, 'YYYYMMDD')) as FULL_DATE,

YEAR,

MONTH,

MONTH#,

DAY;

LOAD * INLINE [

FULL_DATE, YEAR, MONTH, MONTH#, DAY

20160301, 2016, Mar, 3, 1

20160302, 2016, Mar, 3, 2

20160303, 2016, Mar, 3, 3

20160304, 2016, Mar, 3, 4

20160305, 2016, Mar, 3, 5

20160306, 2016, Mar, 3, 6

20160307, 2016, Mar, 3, 7

20160308, 2016, Mar, 3, 8

20160309, 2016, Mar, 3, 9

20160310, 2016, Mar, 3, 10

20160311, 2016, Mar, 3, 11

20160312, 2016, Mar, 3, 12

20160313, 2016, Mar, 3, 13

20160314, 2016, Mar, 3, 14

20160315, 2016, Mar, 3, 15

20160316, 2016, Mar, 3, 16

20160317, 2016, Mar, 3, 17

20160318, 2016, Mar, 3, 18

20160319, 2016, Mar, 3, 19

20160320, 2016, Mar, 3, 20

20160321, 2016, Mar, 3, 21

20160322, 2016, Mar, 3, 22

20160323, 2016, Mar, 3, 23

20160324, 2016, Mar, 3, 24

20160325, 2016, Mar, 3, 25

20160326, 2016, Mar, 3, 26

20160327, 2016, Mar, 3, 27

20160328, 2016, Mar, 3, 28

20160329, 2016, Mar, 3, 29

20160330, 2016, Mar, 3, 30

20160331, 2016, Mar, 3, 31

20160401, 2016, Apr, 4, 1

20160402, 2016, Apr, 4, 2

20160403, 2016, Apr, 4, 3

20160404, 2016, Apr, 4, 4

20160405, 2016, Apr, 4, 5

20160406, 2016, Apr, 4, 6

20160407, 2016, Apr, 4, 7

20160408, 2016, Apr, 4, 8

20160409, 2016, Apr, 4, 9

20160410, 2016, Apr, 4, 10

20160411, 2016, Apr, 4, 11

20160412, 2016, Apr, 4, 12

20160413, 2016, Apr, 4, 13

20160414, 2016, Apr, 4, 14

20160415, 2016, Apr, 4, 15

20160416, 2016, Apr, 4, 16

20160417, 2016, Apr, 4, 17

20160418, 2016, Apr, 4, 18

20160419, 2016, Apr, 4, 19

20160420, 2016, Apr, 4, 20

20160421, 2016, Apr, 4, 21

20160422, 2016, Apr, 4, 22

20160423, 2016, Apr, 4, 23

20160424, 2016, Apr, 4, 24

20160425, 2016, Apr, 4, 25

20160426, 2016, Apr, 4, 26

20160427, 2016, Apr, 4, 27

20160428, 2016, Apr, 4, 28

];

DAYSMONTH:

LOAD FULL_DATE,

MonthName(FULL_DATE) as MONTHYEAR,

Floor(MonthEnd(FULL_DATE)) - Floor(MonthStart(FULL_DATE)) + 1 as DAYSMONTH

Resident Table;

Re: Get Number of Days per Month?

sunny_talwar — Thu, 28 Apr 2016 15:11:34 GMT

Much more elegant

topic Re: Get Number of Days per Month? in QlikView

Solved

Re: Get Number of Days per Month?

Re: Get Number of Days per Month?

Re: Get Number of Days per Month?

Re: Get Number of Days per Month?