Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me with the 'error in set modifier expression' in this code?:
I want to calculate the sales of last month
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.
Thanks Théo, but it still has the same error. Is there another solution? Best, Jen
Can you share me an set of data to make tests?
Sorry I can't, because of privacy issues...
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.