topic Re: Calander in QlikView

Calander

Wed, 09 Dec 2015 15:10:46 GMT

Hi,

How to convert [Mar 2014] as 3/30/2014 and create calander based up on this

out put then calander

Mar 2014---3/30/2014

Apr 2014----4/31/2014

till december 12/31/2014

Anonymous — Wed, 09 Dec 2015 18:29:23 GMT

Hi,

Like this maybe.

TEST:

LOAD F1,

Date(MonthEnd([41699]),'M/DD/YYYY') as Date1,

Sales,

value

FROM

[..\..\..\..\Downloads\calander.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards.

sunny_talwar — Wed, 09 Dec 2015 18:36:02 GMT

I agree with Jannet Santos‌. You should be able to use MonthEnd function to get to the dates you are looking for.

Wed, 09 Dec 2015 18:37:05 GMT

I am agree too. Regards!