topic Re: Invalid Expression in QlikView https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933667#M649646 <HTML><HEAD></HEAD><BODY><P>Please provide script with sample data so that we can help you</P></BODY></HTML> Fri, 25 Sep 2015 06:08:36 GMT sasiparupudi1 2015-09-25T06:08:36Z Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933665#M649643 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Could someone explain why this expression isn't valid in the script.</P><P></P><P>if(max(UNIT.SOLD_DATE) &gt; AddMonths(today(),-3), 'Active') as BUYER_BUYING_STATUS,</P><P></P><P>I'm trying to group buyers that have bought within the last 3 months if they have mark them as 'Active'.</P><P></P><P>Thanks</P><P></P><P>Gareth</P></BODY></HTML> Thu, 24 Sep 2015 14:39:35 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933665#M649643 Anonymous 2015-09-24T14:39:35Z Re: Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933666#M649644 <HTML><HEAD></HEAD><BODY><P>Aggregations in the script like Max(UNIT.SOLD_DATE) need a GROUP BY clause. </P></BODY></HTML> Thu, 24 Sep 2015 14:41:32 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933666#M649644 swuehl 2015-09-24T14:41:32Z Re: Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933667#M649646 <HTML><HEAD></HEAD><BODY><P>Please provide script with sample data so that we can help you</P></BODY></HTML> Fri, 25 Sep 2015 06:08:36 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/933667#M649646 sasiparupudi1 2015-09-25T06:08:36Z