topic Re: Date Logic in QlikView

Date Logic

abhaysingh — Thu, 04 Feb 2016 05:25:30 GMT

Hi Guys,

I have Year and Month as per Fiscal Year in a table, like year 2015 and their Month

Apr,May,Jun, Jul ,Aug, Sep,Oct,Nov,Dec,Jan,Feb,Mar

So i want to create the date like below

01-01-2015,

01-02-2015,

01-03-2015

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2016

01-11-2016

01-12-2016

kindly suggest

settu_periasamy — Thu, 04 Feb 2016 05:36:52 GMT

Hi,

Try this..

Makedate(Year,Month(Date#('Apr','MMM'))) as Date

if your Month is properly formatted, you can just use MakeDate(Year,Month)

abhaysingh — Thu, 04 Feb 2016 05:42:39 GMT

No settu, i am getting dates as Calendar year only

jagan — Thu, 04 Feb 2016 05:48:39 GMT

Hi,

Attach sample data and let us know your expected output. This way it is easier to provide solution. What is Fiscal Year start date?

Regard,

Jagan.

Anonymous — Thu, 04 Feb 2016 06:02:58 GMT

only one date for Every month?

like 01-01-2016 for Apr, no other dates?

PradeepReddy — Thu, 04 Feb 2016 06:08:57 GMT

see the attachment, you are looking some thing like this..

Edit:

Change the date format as per your requirement..

Date(MakeDate(Year,ApplyMap('Month_Number_MAP',Month,'N/A')),'DD-MM-YYYY') as Date1