Solved: Error in set modifier expression

[Jennyy]

Hi, 

Can someone help me with the 'error in set modifier expression' in this code?: 

I want to calculate the sales of last month

Sum({< Year, [Quarter], [Month], week, Day, 

    [Date] = {"$(= '>=' & MonthStart(AddMonths(Max([Date]),-1)) & '<=' & AddMonths(Max([Date]),-1))"},

         $<[Product group]={'Fruit'}>
        -1<[Article name]={'apple'}
                       >}

                                   sales)

[theoat]

Hello,

You can try something like this :

Sum({
< Year,
[Quater],
[Month],
week,
Day,
[Date] = {">=$(=MonthStart(AddMonths(Max([Date]),-1)))<=$(=MonthEnd(AddMonths(Max([Date]),-1)))"},
[Product group] = {'Fruit'},
[Article name] -= {'apple'}
>} 
sales)

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[Jennyy]

Thanks Théo, but it still has the same error. Is there another solution? Best, Jen

[theoat]

Can you share me an set of data to make tests?

[Jennyy]

Sorry I can't, because of privacy issues...

[marcus_sommer]

Just check it step by step and commenting all conditions unless one and the next and the next ...

Beside this the suggestion from Theo should work from a syntax point of view (if all field-names were correct specified) because it's a single set statement with n conditions while your approach was n set statements which weren't correct opened/closed and linked.