date field - how to create new fields

[fmazzarelli]

Hello,

Qlik view and I am using this need.

On excel file I have a date field (example: 05/23/2015)

I placed the import of Excel files, and created a multi box with some fields including the date.

This allows me to make the selection of records to date, but I would need to create two new fields MONTH and YEAR.

How to do?

[sunny_talwar]

You can do it in a Master Calendar or you can do it in your fact table itself.

You just need to do like this if you choose the later technique:

LOAD *,

          Date,

          Month(Date) as Month,

          Year(Date) as Year

FROM ....;

for master calendar you can check out this blog: The Master Calendar

HTH

Best,

Sunny

[fmazzarelli]

It works.

ok.

[sunny_talwar]

Great