topic Date in QlikView

Date

Wed, 18 Dec 2013 14:25:14 GMT

Hello everyone!

I have received a data set that has a date format of 'DD/MM/YYYY'. Is there any way to transfer it to display months and quarters separately? For example, I want to have a list box that will show 'Sept', 'Oct', etc and same for quarters, and be functional.

Thank you,

Anna

Re: Date

Gysbert_Wassenaar — Wed, 18 Dec 2013 14:29:01 GMT

You can create new fields using the date field:

load

MyDate,

month(MyDate) as Month

'Q' & ceil(month(MyDate)/3) as Quarter

...other fields...

from ...somewhere...;

Re: Date

Wed, 18 Dec 2013 14:34:05 GMT

you can try something like below in the script and create a month field

MONTHMAPPING:

Mapping LOAD * INLINE

[ Name,number

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12

];

ApplyMap('MONTHMAPPING', Month(Date(DateField, 'DD/MM/YYYY'))) AS Month

Re: Date

Wed, 18 Dec 2013 14:34:51 GMT

Month function will just return number I guess. we need a map as below

Re: Date

Wed, 18 Dec 2013 14:36:11 GMT

Thank you! it works:)

Re: Date

Wed, 18 Dec 2013 14:36:19 GMT

Thank you!