topic Re: date field - how to create new fields in QlikView

date field - how to create new fields

fmazzarelli — Tue, 02 Jun 2015 18:40:52 GMT

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 — Tue, 02 Jun 2015 18:56:25 GMT

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 — Tue, 02 Jun 2015 19:35:48 GMT

It works.

ok.

sunny_talwar — Tue, 02 Jun 2015 20:05:32 GMT

Great