topic Re: Calander in QlikView

Calander

Wed, 09 Dec 2015 14:08:25 GMT

Hi,

How to use Make date from this format--- 'Jan-2015'

or create this in the form of date Jan-2015 like 1/1/2015 for

Feb 2015 2/1/2015

like this for whole year

sunny_talwar — Wed, 09 Dec 2015 20:25:18 GMT

Try this:

Table:

LOAD Date(A) as Date

FROM

[calander (1).xlsx]

(ooxml, no labels, table is Sheet1);

maxgro — Wed, 09 Dec 2015 20:30:52 GMT

It seems you don't need any interpretation to get a date from your excel

LOAD

Date(A, 'MMM-YYYY') as B

FROM

calander.xlsx

(ooxml, no labels, table is Sheet1);