Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
garethct
Contributor

Invalid Expression

Hi all,

Could someone explain why this expression isn't valid in the script.

if(max(UNIT.SOLD_DATE) > AddMonths(today(),-3), 'Active') as BUYER_BUYING_STATUS,

I'm trying to group buyers that have bought within the last 3 months if they have mark them as 'Active'.

Thanks

Gareth

1 Solution

Accepted Solutions
MVP
MVP

Re: Invalid Expression

Aggregations in the script like Max(UNIT.SOLD_DATE) need a GROUP BY clause.

2 Replies
MVP
MVP

Re: Invalid Expression

Aggregations in the script like Max(UNIT.SOLD_DATE) need a GROUP BY clause.

sasiparupudi1
Honored Contributor III

Re: Invalid Expression

Please provide script with sample data so that we can help you

Community Browser