Re: Time stamp Drill down for last year, month, week
In your transaction table where you have the timestamp create a new field called %date like the script below.
date(SubField(Timestamp, ' ',1)) as %date
Then, after you created this field, run the code seen below to create an master calendar.
for each _date in FieldValueList ('%date')
'$(_date)' as %date,
year('$(_date)') as Year,
month('$(_date)') as Month,
Week('$(_date)') as Week,
Weekday('$(_date)') as Weekday
You can expand the fields in this calendar according to your own need ant taste. (Google search for master calendar Qlik to find other more detailed master calendars.
Take a look at my earlier comment on how to create drill down dimensions. Be aware when using week in drill down from month, a week can belong to two months.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes