Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

how to make date from month and year field in qliksense

Hi,

I have the fields Month and Year in my table and now I have to extract date from Month and Year field, Please suggest how can achieve it.

1 Reply
Partner
Partner

Re: how to make date from month and year field in qliksense

load *, date(monthstart(Date#(Month&'/'&Year,'MM/YYYY'))) as Date Inline [

Month, Year

01, 2017

02,2017

03,2017

];

result:

Capture.PNG