Re: Error in set modifier expression - Qlik Community

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.

Error in set modifier expression

Scripting