Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
MVP
MVP

Re: Invalid Expression

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Invalid Expression

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

View solution in original post

Honored Contributor III

Re: Invalid Expression

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