topic Re: Current and previous months in QlikView

Current and previous months

Anonymous — Tue, 16 Jul 2013 14:00:28 GMT

Hi!

Trying to add action to select current and previous months in max year as a default, Month(Max([Date])) returns only the current month

Thanks

Kwame

Re: Current and previous months

Tue, 16 Jul 2013 14:11:14 GMT

Kwame,

Fot the field WEEK I defined an action as ='<=$(=week(today()))'

This sets all the weeks.

For te field YEAR I defined an action as =year(today())

The combination of these two actions sets the YEAR and the WEEKS.

Regards,

Gerrit

Re: Current and previous months

Anonymous — Tue, 16 Jul 2013 14:46:08 GMT

try you

Month(addmonth(Max(date),-1))

Re: Current and previous months

Anonymous — Tue, 16 Jul 2013 15:09:18 GMT

Hi! Guys

The expressions are not giving the desired results.

=vMaxYear returns the current month ie. 2013 and now i would want all the months selected suppose the current month is July. So essentially when i open the document the 2013 and months Jan,Feb,Mar,April,May,June and July should all be selected

Thanks