topic Re: Date field for month start in QlikView

Date field for month start

Anonymous — Mon, 28 Mar 2016 06:20:08 GMT

Hi All,

I loaded data from Jan'15 to Jan'16( 13 Tables). now I need to add one date column that contains only start date of the month.

P FA.

Thanks,

Krishna.

Kushal_Chawda — Mon, 28 Mar 2016 06:28:27 GMT

How do you recognize that this data is from jan 15 to jan 16?

Anonymous — Mon, 28 Mar 2016 06:31:14 GMT

Hi Try this ,

MonthStart(Month_HR)

avinashelite — Mon, 28 Mar 2016 06:32:10 GMT

if you need only the 01-01-2015 for all then , you can add a column like

makedate(2015,01,01) as Month_Hr

if you want it dynamically please tell us how to to identify the month

its_anandrjs — Mon, 28 Mar 2016 06:48:33 GMT

What is the logic for field Month_HR should be 01-01-2015

Regards

Anand

Anonymous — Mon, 28 Mar 2016 14:58:07 GMT

Hi,

I loaded data from Excel Sheets.Date fields are Date of joining, Effective date. KPI is Head count VS Every Month.

Regards,

Krishna