Set Analysis not working

[#1]

=sum(({<MasterDate_Year={$(=max(MasterDate_Year))},

CustomerNo = p({<MasterDate_Year={$(=max(MasterDate_Year)-1)} CustomerNo>}) Sage.ExtensionAmt)

Three fields at play here...

MasterDate_Year = year field

CustomerNo = CustomerNo

Sage.ExtensionAmt = field to be aggregated

Qlikview is saying the expression is OK, but i'm getting "Error: Error in expressions: ')' expected.

Any ideas?

Trying to get sales for customers that had a purchase Last year.

-David

[MK_QSL]

Try This

SUM({<

     MasterDate_Year = {'$(=Max(MasterDate_Year))'},

     CustomerNo = P({1<MasterDate_Year = {'$(=Max(MasterDate_Year)-1)'}CustomerNo>})

     >}Sage.ExtensionAmt)

[#3]

Weird...it's giving me the squiggly line under the last field, and not returning results...

[MK_QSL · Accepted solution]

This should work

=SUM({<MasterDate_Year = {'$(=Max(MasterDate_Year))'}, CustomerNo = P({1<MasterDate_Year = {'$(=Max(MasterDate_Year)-1)'}>})>}Sage.ExtensionAmt)

[#5]

Great! Thanks for your help!