topic Re: Max week as a calculated dimesion in QlikView

Max week as a calculated dimesion

Thu, 26 Mar 2015 12:48:53 GMT

Hi, guys!

I have a number of weeks in my file. For pivot table I want just the last week as a dimension.

Any suggestions how to do that?

Re: Max week as a calculated dimesion

MK_QSL — Thu, 26 Mar 2015 12:53:57 GMT

How is your week field? ie. normal week number of weekyear?

Use below

=Max(TOTAL {<Year= {'$(=Max(Year))'}>}Week)

Re: Max week as a calculated dimesion

Thu, 26 Mar 2015 13:03:23 GMT

I just have dates as like DD-MMM as a week

Re: Max week as a calculated dimesion

rajkumarb — Thu, 26 Mar 2015 13:06:41 GMT

you can use Week(max(field name))

Re: Max week as a calculated dimesion

Thu, 26 Mar 2015 13:52:21 GMT

Hi, it's not working

Re: Max week as a calculated dimesion

rajkumarb — Thu, 26 Mar 2015 14:30:42 GMT

hI diana

=Max(WEEK(weekstart(date_field_name)))

Re: Max week as a calculated dimesion

MK_QSL — Thu, 26 Mar 2015 14:34:00 GMT

=Max(TOTAL {<Year= {'$(=Max(Year))'}>}(Date#(Week,'DD-MMM')))

Re: Max week as a calculated dimesion

ramoncova06 — Thu, 26 Mar 2015 14:43:59 GMT

if you want to use is as a dimension, then you need to use aggr

=aggr(max(WEEK),$Field)

though this is conditioned to how you date is set up so you might want change it to a date format something like date(your date&'-'year), so then it would be recognized as a number instead of a string