Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
It works.
ok.
Great