topic Re: Selecting Last 3 months in QlikView

Selecting Last 3 months

samuel_brierley — Thu, 13 Aug 2015 08:33:12 GMT

Hi all,

Can anyone see where im going wrong with the below expression to select the last 3 months?

='>='&MakeDate(year(now()),AddMonths(now(),-3),1)&'<='&MakeDate(year(now()),month(now()),1)

sunny_talwar — Thu, 13 Aug 2015 08:35:53 GMT

Try this:

='>=' & MakeDate(Year(Now()), Month(AddMonths(Now(), -3)), 1) & '<=' & MakeDate(Year(Now()), Month(Now()), 1)

samuel_brierley — Thu, 13 Aug 2015 08:38:35 GMT

hahahha always something simple

thanks

sunny_talwar — Thu, 13 Aug 2015 08:39:14 GMT

Difference between your expression and the new expression in a text box object just so you can visualize the difference:

HTH

Best,

Sunny

jonathandienst — Thu, 13 Aug 2015 08:40:26 GMT

In what context are you using that conditional. The syntax is wrong for set analysis. Maybe this:

<datefield = {">=$(=MonthStart(now(), -3)) <=$(=MonthEnd(now()))"}>

sunny_talwar — Thu, 13 Aug 2015 08:51:29 GMT

Hahahaha yup

I am glad we were able to quickly figure it out. I suggest closing this thread by marking the correct answer and any helpful answers.

Best,

Sunny