Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
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

Highlighted
sasiparupudi1
Honored Contributor III

Re: Invalid Expression

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