Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis not working

=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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

This should work

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

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Try This

SUM({<

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

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

     >}Sage.ExtensionAmt)

Not applicable
Author

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

MK_QSL
MVP
MVP

This should work

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

Not applicable
Author

Great! Thanks for your help!