Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner
Partner

date field - how to create new fields

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?

3 Replies
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
Partner
Partner
Author

It works.

ok.

sunny_talwar

Great