Discussion Board for collaboration related to QlikView App Development.
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?
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:
Month(Date) as Month,
Year(Date) as Year
for master calendar you can check out this blog: The Master Calendar